File manager - Edit - /home/autoph/public_html/projects/Rating-AutoHub/public/css/datatables-buttons.zip
Back
PK ׁ�Zu)�E E css/buttons.bootstrap4.cssnu �[��� @keyframes dtb-spinner { 100% { transform: rotate(360deg); } } @-o-keyframes dtb-spinner { 100% { -o-transform: rotate(360deg); transform: rotate(360deg); } } @-ms-keyframes dtb-spinner { 100% { -ms-transform: rotate(360deg); transform: rotate(360deg); } } @-webkit-keyframes dtb-spinner { 100% { -webkit-transform: rotate(360deg); transform: rotate(360deg); } } @-moz-keyframes dtb-spinner { 100% { -moz-transform: rotate(360deg); transform: rotate(360deg); } } div.dt-button-info { position: fixed; top: 50%; left: 50%; width: 400px; margin-top: -100px; margin-left: -200px; background-color: white; border: 2px solid #111; box-shadow: 3px 3px 8px rgba(0, 0, 0, 0.3); border-radius: 3px; text-align: center; z-index: 21; } div.dt-button-info h2 { padding: 0.5em; margin: 0; font-weight: normal; border-bottom: 1px solid #ddd; background-color: #f3f3f3; } div.dt-button-info > div { padding: 1em; } div.dt-button-collection-title { text-align: center; padding: 0.3em 0 0.5em; font-size: 0.9em; } div.dt-button-collection-title:empty { display: none; } div.dt-button-collection { position: absolute; z-index: 2001; } div.dt-button-collection div.dropdown-menu { display: block; z-index: 2002; min-width: 100%; } div.dt-button-collection div.dt-button-collection-title { background-color: white; border: 1px solid rgba(0, 0, 0, 0.15); } div.dt-button-collection.fixed { position: fixed; top: 50%; left: 50%; margin-left: -75px; border-radius: 0; } div.dt-button-collection.fixed.two-column { margin-left: -200px; } div.dt-button-collection.fixed.three-column { margin-left: -225px; } div.dt-button-collection.fixed.four-column { margin-left: -300px; } div.dt-button-collection > :last-child { display: block !important; -webkit-column-gap: 8px; -moz-column-gap: 8px; -ms-column-gap: 8px; -o-column-gap: 8px; column-gap: 8px; } div.dt-button-collection > :last-child > * { -webkit-column-break-inside: avoid; break-inside: avoid; } div.dt-button-collection.two-column { width: 400px; } div.dt-button-collection.two-column > :last-child { padding-bottom: 1px; -webkit-column-count: 2; -moz-column-count: 2; -ms-column-count: 2; -o-column-count: 2; column-count: 2; } div.dt-button-collection.three-column { width: 450px; } div.dt-button-collection.three-column > :last-child { padding-bottom: 1px; -webkit-column-count: 3; -moz-column-count: 3; -ms-column-count: 3; -o-column-count: 3; column-count: 3; } div.dt-button-collection.four-column { width: 600px; } div.dt-button-collection.four-column > :last-child { padding-bottom: 1px; -webkit-column-count: 4; -moz-column-count: 4; -ms-column-count: 4; -o-column-count: 4; column-count: 4; } div.dt-button-collection .dt-button { border-radius: 0; } div.dt-button-collection.fixed { max-width: none; } div.dt-button-collection.fixed:before, div.dt-button-collection.fixed:after { display: none; } div.dt-button-background { position: fixed; top: 0; left: 0; width: 100%; height: 100%; z-index: 999; } @media screen and (max-width: 767px) { div.dt-buttons { float: none; width: 100%; text-align: center; margin-bottom: 0.5em; } div.dt-buttons a.btn { float: none; } } div.dt-buttons button.btn.processing, div.dt-buttons div.btn.processing, div.dt-buttons a.btn.processing { color: rgba(0, 0, 0, 0.2); } div.dt-buttons button.btn.processing:after, div.dt-buttons div.btn.processing:after, div.dt-buttons a.btn.processing:after { position: absolute; top: 50%; left: 50%; width: 16px; height: 16px; margin: -8px 0 0 -8px; box-sizing: border-box; display: block; content: ' '; border: 2px solid #282828; border-radius: 50%; border-left-color: transparent; border-right-color: transparent; animation: dtb-spinner 1500ms infinite linear; -o-animation: dtb-spinner 1500ms infinite linear; -ms-animation: dtb-spinner 1500ms infinite linear; -webkit-animation: dtb-spinner 1500ms infinite linear; -moz-animation: dtb-spinner 1500ms infinite linear; } PK ׁ�Z�҂�� � css/buttons.bootstrap4.min.cssnu �[��� @keyframes dtb-spinner{100%{transform:rotate(360deg)}}@-o-keyframes dtb-spinner{100%{-o-transform:rotate(360deg);transform:rotate(360deg)}}@-ms-keyframes dtb-spinner{100%{-ms-transform:rotate(360deg);transform:rotate(360deg)}}@-webkit-keyframes dtb-spinner{100%{-webkit-transform:rotate(360deg);transform:rotate(360deg)}}@-moz-keyframes dtb-spinner{100%{-moz-transform:rotate(360deg);transform:rotate(360deg)}}div.dt-button-info{position:fixed;top:50%;left:50%;width:400px;margin-top:-100px;margin-left:-200px;background-color:white;border:2px solid #111;box-shadow:3px 3px 8px rgba(0,0,0,0.3);border-radius:3px;text-align:center;z-index:21}div.dt-button-info h2{padding:0.5em;margin:0;font-weight:normal;border-bottom:1px solid #ddd;background-color:#f3f3f3}div.dt-button-info>div{padding:1em}div.dt-button-collection-title{text-align:center;padding:0.3em 0 0.5em;font-size:0.9em}div.dt-button-collection-title:empty{display:none}div.dt-button-collection{position:absolute;z-index:2001}div.dt-button-collection div.dropdown-menu{display:block;z-index:2002;min-width:100%}div.dt-button-collection div.dt-button-collection-title{background-color:white;border:1px solid rgba(0,0,0,0.15)}div.dt-button-collection.fixed{position:fixed;top:50%;left:50%;margin-left:-75px;border-radius:0}div.dt-button-collection.fixed.two-column{margin-left:-200px}div.dt-button-collection.fixed.three-column{margin-left:-225px}div.dt-button-collection.fixed.four-column{margin-left:-300px}div.dt-button-collection>:last-child{display:block !important;-webkit-column-gap:8px;-moz-column-gap:8px;-ms-column-gap:8px;-o-column-gap:8px;column-gap:8px}div.dt-button-collection>:last-child>*{-webkit-column-break-inside:avoid;break-inside:avoid}div.dt-button-collection.two-column{width:400px}div.dt-button-collection.two-column>:last-child{padding-bottom:1px;-webkit-column-count:2;-moz-column-count:2;-ms-column-count:2;-o-column-count:2;column-count:2}div.dt-button-collection.three-column{width:450px}div.dt-button-collection.three-column>:last-child{padding-bottom:1px;-webkit-column-count:3;-moz-column-count:3;-ms-column-count:3;-o-column-count:3;column-count:3}div.dt-button-collection.four-column{width:600px}div.dt-button-collection.four-column>:last-child{padding-bottom:1px;-webkit-column-count:4;-moz-column-count:4;-ms-column-count:4;-o-column-count:4;column-count:4}div.dt-button-collection .dt-button{border-radius:0}div.dt-button-collection.fixed{max-width:none}div.dt-button-collection.fixed:before,div.dt-button-collection.fixed:after{display:none}div.dt-button-background{position:fixed;top:0;left:0;width:100%;height:100%;z-index:999}@media screen and (max-width: 767px){div.dt-buttons{float:none;width:100%;text-align:center;margin-bottom:0.5em}div.dt-buttons a.btn{float:none}}div.dt-buttons button.btn.processing,div.dt-buttons div.btn.processing,div.dt-buttons a.btn.processing{color:rgba(0,0,0,0.2)}div.dt-buttons button.btn.processing:after,div.dt-buttons div.btn.processing:after,div.dt-buttons a.btn.processing:after{position:absolute;top:50%;left:50%;width:16px;height:16px;margin:-8px 0 0 -8px;box-sizing:border-box;display:block;content:' ';border:2px solid #282828;border-radius:50%;border-left-color:transparent;border-right-color:transparent;animation:dtb-spinner 1500ms infinite linear;-o-animation:dtb-spinner 1500ms infinite linear;-ms-animation:dtb-spinner 1500ms infinite linear;-webkit-animation:dtb-spinner 1500ms infinite linear;-moz-animation:dtb-spinner 1500ms infinite linear} PK ׁ�Z�ܫ��e �e js/buttons.flash.min.jsnu �[��� (function(g){"function"===typeof define&&define.amd?define(["jquery","datatables.net","datatables.net-buttons"],function(j){return g(j,window,document)}):"object"===typeof exports?module.exports=function(j,m){j||(j=window);if(!m||!m.fn.dataTable)m=require("datatables.net")(j,m).$;m.fn.dataTable.Buttons||require("datatables.net-buttons")(j,m);return g(m,j,j.document)}:g(jQuery,window,document)})(function(g,j,m,p){function w(a){for(var b="";0<=a;)b=String.fromCharCode(a%26+65)+b,a=Math.floor(a/26)- 1;return b}function o(a,b,d){var c=a.createElement(b);d&&(d.attr&&g(c).attr(d.attr),d.children&&g.each(d.children,function(a,b){c.appendChild(b)}),null!==d.text&&d.text!==p&&c.appendChild(a.createTextNode(d.text)));return c}function C(a,b){var d=a.header[b].length,c;a.footer&&a.footer[b].length>d&&(d=a.footer[b].length);for(var e=0,f=a.body.length;e<f;e++)if(c=a.body[e][b],c=null!==c&&c!==p?c.toString():"",-1!==c.indexOf("\n")?(c=c.split("\n"),c.sort(function(a,b){return b.length-a.length}),c=c[0].length): c=c.length,c>d&&(d=c),40<d)return 52;d*=1.3;return 6<d?d:6}function x(a){r===p&&(r=-1===v.serializeToString(g.parseXML(q["xl/worksheets/sheet1.xml"])).indexOf("xmlns:r"));g.each(a,function(b,d){if(g.isPlainObject(d))x(d);else{if(r){var c=d.childNodes[0],e,f,i=[];for(e=c.attributes.length-1;0<=e;e--){f=c.attributes[e].nodeName;var k=c.attributes[e].nodeValue;-1!==f.indexOf(":")&&(i.push({name:f,value:k}),c.removeAttribute(f))}e=0;for(f=i.length;e<f;e++)k=d.createAttribute(i[e].name.replace(":","_dt_b_namespace_token_")), k.value=i[e].value,c.setAttributeNode(k)}c=v.serializeToString(d);r&&(-1===c.indexOf("<?xml")&&(c='<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+c),c=c.replace(/_dt_b_namespace_token_/g,":"));c=c.replace(/<([^<>]*?) xmlns=""([^<>]*?)>/g,"<$1 $2>");a[b]=c}})}var h=g.fn.dataTable,i={version:"1.0.4-TableTools2",clients:{},moviePath:"",nextId:1,$:function(a){"string"==typeof a&&(a=m.getElementById(a));a.addClass||(a.hide=function(){this.style.display="none"},a.show=function(){this.style.display= ""},a.addClass=function(a){this.removeClass(a);this.className+=" "+a},a.removeClass=function(a){this.className=this.className.replace(RegExp("\\s*"+a+"\\s*")," ").replace(/^\s+/,"").replace(/\s+$/,"")},a.hasClass=function(a){return!!this.className.match(RegExp("\\s*"+a+"\\s*"))});return a},setMoviePath:function(a){this.moviePath=a},dispatch:function(a,b,d){(a=this.clients[a])&&a.receiveEvent(b,d)},log:function(a){console.log("Flash: "+a)},register:function(a,b){this.clients[a]=b},getDOMObjectPosition:function(a){var b= {left:0,top:0,width:a.width?a.width:a.offsetWidth,height:a.height?a.height:a.offsetHeight};""!==a.style.width&&(b.width=a.style.width.replace("px",""));""!==a.style.height&&(b.height=a.style.height.replace("px",""));for(;a;)b.left+=a.offsetLeft,b.top+=a.offsetTop,a=a.offsetParent;return b},Client:function(a){this.handlers={};this.id=i.nextId++;this.movieId="ZeroClipboard_TableToolsMovie_"+this.id;i.register(this.id,this);a&&this.glue(a)}};i.Client.prototype={id:0,ready:!1,movie:null,clipText:"",fileName:"", action:"copy",handCursorEnabled:!0,cssEffects:!0,handlers:null,sized:!1,sheetName:"",glue:function(a,b){this.domElement=i.$(a);var d=99;this.domElement.style.zIndex&&(d=parseInt(this.domElement.style.zIndex,10)+1);var c=i.getDOMObjectPosition(this.domElement);this.div=m.createElement("div");var e=this.div.style;e.position="absolute";e.left="0px";e.top="0px";e.width=c.width+"px";e.height=c.height+"px";e.zIndex=d;"undefined"!=typeof b&&""!==b&&(this.div.title=b);0!==c.width&&0!==c.height&&(this.sized= !0);this.domElement&&(this.domElement.appendChild(this.div),this.div.innerHTML=this.getHTML(c.width,c.height).replace(/&/g,"&"))},positionElement:function(){var a=i.getDOMObjectPosition(this.domElement),b=this.div.style;b.position="absolute";b.width=a.width+"px";b.height=a.height+"px";0!==a.width&&0!==a.height&&(this.sized=!0,b=this.div.childNodes[0],b.width=a.width,b.height=a.height)},getHTML:function(a,b){var d="",c="id="+this.id+"&width="+a+"&height="+b;if(navigator.userAgent.match(/MSIE/))var e= location.href.match(/^https/i)?"https://":"http://",d=d+('<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="'+e+'download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=10,0,0,0" width="'+a+'" height="'+b+'" id="'+this.movieId+'" align="middle"><param name="allowScriptAccess" value="always" /><param name="allowFullScreen" value="false" /><param name="movie" value="'+i.moviePath+'" /><param name="loop" value="false" /><param name="menu" value="false" /><param name="quality" value="best" /><param name="bgcolor" value="#ffffff" /><param name="flashvars" value="'+ c+'"/><param name="wmode" value="transparent"/></object>');else d+='<embed id="'+this.movieId+'" src="'+i.moviePath+'" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="'+a+'" height="'+b+'" name="'+this.movieId+'" align="middle" allowScriptAccess="always" allowFullScreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="'+c+'" wmode="transparent" />';return d},hide:function(){this.div&&(this.div.style.left="-2000px")}, show:function(){this.reposition()},destroy:function(){var a=this;this.domElement&&this.div&&(g(this.div).remove(),this.div=this.domElement=null,g.each(i.clients,function(b,d){d===a&&delete i.clients[b]}))},reposition:function(a){a&&((this.domElement=i.$(a))||this.hide());if(this.domElement&&this.div){var a=i.getDOMObjectPosition(this.domElement),b=this.div.style;b.left=""+a.left+"px";b.top=""+a.top+"px"}},clearText:function(){this.clipText="";this.ready&&this.movie.clearText()},appendText:function(a){this.clipText+= a;this.ready&&this.movie.appendText(a)},setText:function(a){this.clipText=a;this.ready&&this.movie.setText(a)},setFileName:function(a){this.fileName=a;this.ready&&this.movie.setFileName(a)},setSheetData:function(a){this.ready&&this.movie.setSheetData(JSON.stringify(a))},setAction:function(a){this.action=a;this.ready&&this.movie.setAction(a)},addEventListener:function(a,b){a=a.toString().toLowerCase().replace(/^on/,"");this.handlers[a]||(this.handlers[a]=[]);this.handlers[a].push(b)},setHandCursor:function(a){this.handCursorEnabled= a;this.ready&&this.movie.setHandCursor(a)},setCSSEffects:function(a){this.cssEffects=!!a},receiveEvent:function(a,b){var d,a=a.toString().toLowerCase().replace(/^on/,"");switch(a){case "load":this.movie=m.getElementById(this.movieId);if(!this.movie){d=this;setTimeout(function(){d.receiveEvent("load",null)},1);return}if(!this.ready&&navigator.userAgent.match(/Firefox/)&&navigator.userAgent.match(/Windows/)){d=this;setTimeout(function(){d.receiveEvent("load",null)},100);this.ready=!0;return}this.ready= !0;this.movie.clearText();this.movie.appendText(this.clipText);this.movie.setFileName(this.fileName);this.movie.setAction(this.action);this.movie.setHandCursor(this.handCursorEnabled);break;case "mouseover":this.domElement&&this.cssEffects&&this.recoverActive&&this.domElement.addClass("active");break;case "mouseout":this.domElement&&this.cssEffects&&(this.recoverActive=!1,this.domElement.hasClass("active")&&(this.domElement.removeClass("active"),this.recoverActive=!0));break;case "mousedown":this.domElement&& this.cssEffects&&this.domElement.addClass("active");break;case "mouseup":this.domElement&&this.cssEffects&&(this.domElement.removeClass("active"),this.recoverActive=!1)}if(this.handlers[a])for(var c=0,e=this.handlers[a].length;c<e;c++){var f=this.handlers[a][c];if("function"==typeof f)f(this,b);else if("object"==typeof f&&2==f.length)f[0][f[1]](this,b);else if("string"==typeof f)j[f](this,b)}}};i.hasFlash=function(){try{if(new ActiveXObject("ShockwaveFlash.ShockwaveFlash"))return!0}catch(a){if(navigator.mimeTypes&& navigator.mimeTypes["application/x-shockwave-flash"]!==p&&navigator.mimeTypes["application/x-shockwave-flash"].enabledPlugin)return!0}return!1};j.ZeroClipboard_TableTools=i;var y=function(a,b){b.attr("id");b.parents("html").length?a.glue(b[0],""):setTimeout(function(){y(a,b)},500)},D=function(a){var b="Sheet1";a.sheetName&&(b=a.sheetName.replace(/[\[\]\*\/\\\?\:]/g,""));return b},t=function(a,b){var d=b.match(/[\s\S]{1,8192}/g)||[];a.clearText();for(var c=0,e=d.length;c<e;c++)a.appendText(d[c])}, z=function(a){return a.newline?a.newline:navigator.userAgent.match(/Windows/)?"\r\n":"\n"},A=function(a,b){for(var d=z(b),c=a.buttons.exportData(b.exportOptions),e=b.fieldBoundary,f=b.fieldSeparator,g=RegExp(e,"g"),i=b.escapeChar!==p?b.escapeChar:"\\",j=function(a){for(var b="",c=0,d=a.length;c<d;c++)0<c&&(b+=f),b+=e?e+(""+a[c]).replace(g,i+e)+e:a[c];return b},m=b.header?j(c.header)+d:"",o=b.footer&&c.footer?d+j(c.footer):"",n=[],l=0,h=c.body.length;l<h;l++)n.push(j(c.body[l]));return{str:m+n.join(d)+ o,rows:n.length}},u={available:function(){return i.hasFlash()},init:function(a,b,d){i.moviePath=h.Buttons.swfPath;var c=new i.Client;c.setHandCursor(!0);c.addEventListener("mouseDown",function(){d._fromFlash=!0;a.button(b[0]).trigger();d._fromFlash=!1});y(c,b);d._flash=c},destroy:function(a,b,d){d._flash.destroy()},fieldSeparator:",",fieldBoundary:'"',exportOptions:{},title:"*",messageTop:"*",messageBottom:"*",filename:"*",extension:".csv",header:!0,footer:!1},v="",v="undefined"===typeof j.XMLSerializer? new function(){this.serializeToString=function(a){return a.xml}}:new XMLSerializer,r,q={"_rels/.rels":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/></Relationships>',"xl/_rels/workbook.xml.rels":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/></Relationships>', "[Content_Types].xml":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types"><Default Extension="xml" ContentType="application/xml" /><Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml" /><Default Extension="jpeg" ContentType="image/jpeg" /><Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" /><Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" /><Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml" /></Types>', "xl/workbook.xml":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><fileVersion appName="xl" lastEdited="5" lowestEdited="5" rupBuild="24816"/><workbookPr showInkAnnotation="0" autoCompressPictures="0"/><bookViews><workbookView xWindow="0" yWindow="0" windowWidth="25600" windowHeight="19020" tabRatio="500"/></bookViews><sheets><sheet name="" sheetId="1" r:id="rId1"/></sheets></workbook>', "xl/worksheets/sheet1.xml":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><sheetData/><mergeCells count="0"/></worksheet>',"xl/styles.xml":'<?xml version="1.0" encoding="UTF-8"?><styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><numFmts count="6"><numFmt numFmtId="164" formatCode="#,##0.00_- [$$-45C]"/><numFmt numFmtId="165" formatCode=""£"#,##0.00"/><numFmt numFmtId="166" formatCode="[$€-2] #,##0.00"/><numFmt numFmtId="167" formatCode="0.0%"/><numFmt numFmtId="168" formatCode="#,##0;(#,##0)"/><numFmt numFmtId="169" formatCode="#,##0.00;(#,##0.00)"/></numFmts><fonts count="5" x14ac:knownFonts="1"><font><sz val="11" /><name val="Calibri" /></font><font><sz val="11" /><name val="Calibri" /><color rgb="FFFFFFFF" /></font><font><sz val="11" /><name val="Calibri" /><b /></font><font><sz val="11" /><name val="Calibri" /><i /></font><font><sz val="11" /><name val="Calibri" /><u /></font></fonts><fills count="6"><fill><patternFill patternType="none" /></fill><fill><patternFill patternType="none" /></fill><fill><patternFill patternType="solid"><fgColor rgb="FFD9D9D9" /><bgColor indexed="64" /></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="FFD99795" /><bgColor indexed="64" /></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="ffc6efce" /><bgColor indexed="64" /></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="ffc6cfef" /><bgColor indexed="64" /></patternFill></fill></fills><borders count="2"><border><left /><right /><top /><bottom /><diagonal /></border><border diagonalUp="false" diagonalDown="false"><left style="thin"><color auto="1" /></left><right style="thin"><color auto="1" /></right><top style="thin"><color auto="1" /></top><bottom style="thin"><color auto="1" /></bottom><diagonal /></border></borders><cellStyleXfs count="1"><xf numFmtId="0" fontId="0" fillId="0" borderId="0" /></cellStyleXfs><cellXfs count="61"><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment horizontal="left"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment horizontal="center"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment horizontal="right"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment horizontal="fill"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment textRotation="90"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment wrapText="1"/></xf><xf numFmtId="9" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="164" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="165" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="166" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="167" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="168" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="169" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="3" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="4" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/></cellXfs><cellStyles count="1"><cellStyle name="Normal" xfId="0" builtinId="0" /></cellStyles><dxfs count="0" /><tableStyles count="0" defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotStyleMedium4" /></styleSheet>'}, B=[{match:/^\-?\d+\.\d%$/,style:60,fmt:function(a){return a/100}},{match:/^\-?\d+\.?\d*%$/,style:56,fmt:function(a){return a/100}},{match:/^\-?\$[\d,]+.?\d*$/,style:57},{match:/^\-?£[\d,]+.?\d*$/,style:58},{match:/^\-?€[\d,]+.?\d*$/,style:59},{match:/^\([\d,]+\)$/,style:61,fmt:function(a){return-1*a.replace(/[\(\)]/g,"")}},{match:/^\([\d,]+\.\d{2}\)$/,style:62,fmt:function(a){return-1*a.replace(/[\(\)]/g,"")}},{match:/^[\d,]+$/,style:63},{match:/^[\d,]+\.\d{2}$/,style:64}];h.Buttons.swfPath="//cdn.datatables.net/buttons/"+ h.Buttons.version+"/swf/flashExport.swf";h.Api.register("buttons.resize()",function(){g.each(i.clients,function(a,b){b.domElement!==p&&b.domElement.parentNode&&b.positionElement()})});h.ext.buttons.copyFlash=g.extend({},u,{className:"buttons-copy buttons-flash",text:function(a){return a.i18n("buttons.copy","Copy")},action:function(a,b,d,c){if(c._fromFlash){this.processing(!0);var a=c._flash,e=A(b,c),d=b.buttons.exportInfo(c),f=z(c),e=e.str;d.title&&(e=d.title+f+f+e);d.messageTop&&(e=d.messageTop+ f+f+e);d.messageBottom&&(e=e+f+f+d.messageBottom);c.customize&&(e=c.customize(e,c,b));a.setAction("copy");t(a,e);this.processing(!1);b.buttons.info(b.i18n("buttons.copyTitle","Copy to clipboard"),b.i18n("buttons.copySuccess",{_:"Copied %d rows to clipboard",1:"Copied 1 row to clipboard"},data.rows),3E3)}},fieldSeparator:"\t",fieldBoundary:""});h.ext.buttons.csvFlash=g.extend({},u,{className:"buttons-csv buttons-flash",text:function(a){return a.i18n("buttons.csv","CSV")},action:function(a,b,d,c){var a= c._flash,e=A(b,c),d=b.buttons.exportInfo(c),b=c.customize?c.customize(e.str,c,b):e.str;a.setAction("csv");a.setFileName(d.filename);t(a,b)},escapeChar:'"'});h.ext.buttons.excelFlash=g.extend({},u,{className:"buttons-excel buttons-flash",text:function(a){return a.i18n("buttons.excel","Excel")},action:function(a,b,d,c){this.processing(!0);var a=c._flash,e=0,f=g.parseXML(q["xl/worksheets/sheet1.xml"]),i=f.getElementsByTagName("sheetData")[0],d={_rels:{".rels":g.parseXML(q["_rels/.rels"])},xl:{_rels:{"workbook.xml.rels":g.parseXML(q["xl/_rels/workbook.xml.rels"])}, "workbook.xml":g.parseXML(q["xl/workbook.xml"]),"styles.xml":g.parseXML(q["xl/styles.xml"]),worksheets:{"sheet1.xml":f}},"[Content_Types].xml":g.parseXML(q["[Content_Types].xml"])},k=b.buttons.exportData(c.exportOptions),j,m,h=function(a){j=e+1;m=o(f,"row",{attr:{r:j}});for(var b=0,d=a.length;b<d;b++){var g=w(b)+""+j,h=null;if(null===a[b]||a[b]===p||""===a[b])if(!0===c.createEmptyCells)a[b]="";else continue;a[b]="function"===typeof a[b].trim?a[b].trim():a[b];for(var k=0,n=B.length;k<n;k++){var l= B[k];if(a[b].match&&!a[b].match(/^0\d+/)&&a[b].match(l.match)){h=a[b].replace(/[^\d\.\-]/g,"");l.fmt&&(h=l.fmt(h));h=o(f,"c",{attr:{r:g,s:l.style},children:[o(f,"v",{text:h})]});break}}h||("number"===typeof a[b]||a[b].match&&a[b].match(/^-?\d+(\.\d+)?$/)&&!a[b].match(/^0\d+/)?h=o(f,"c",{attr:{t:"n",r:g},children:[o(f,"v",{text:a[b]})]}):(l=!a[b].replace?a[b]:a[b].replace(/[\x00-\x09\x0B\x0C\x0E-\x1F\x7F-\x9F]/g,""),h=o(f,"c",{attr:{t:"inlineStr",r:g},children:{row:o(f,"is",{children:{row:o(f,"t", {text:l})}})}})));m.appendChild(h)}i.appendChild(m);e++};g("sheets sheet",d.xl["workbook.xml"]).attr("name",D(c));c.customizeData&&c.customizeData(k);var n=function(a,b){var c=g("mergeCells",f);c[0].appendChild(o(f,"mergeCell",{attr:{ref:"A"+a+":"+w(b)+a}}));c.attr("count",c.attr("count")+1);g("row:eq("+(a-1)+") c",f).attr("s","51")},l=b.buttons.exportInfo(c);l.title&&(h([l.title],e),n(e,k.header.length-1));l.messageTop&&(h([l.messageTop],e),n(e,k.header.length-1));c.header&&(h(k.header,e),g("row:last c", f).attr("s","2"));for(var s=0,r=k.body.length;s<r;s++)h(k.body[s],e);c.footer&&k.footer&&(h(k.footer,e),g("row:last c",f).attr("s","2"));l.messageBottom&&(h([l.messageBottom],e),n(e,k.header.length-1));h=o(f,"cols");g("worksheet",f).prepend(h);n=0;for(s=k.header.length;n<s;n++)h.appendChild(o(f,"col",{attr:{min:n+1,max:n+1,width:C(k,n),customWidth:1}}));c.customize&&c.customize(d,c,b);x(d);a.setAction("excel");a.setFileName(l.filename);a.setSheetData(d);t(a,"");this.processing(!1)},extension:".xlsx", createEmptyCells:!1});h.ext.buttons.pdfFlash=g.extend({},u,{className:"buttons-pdf buttons-flash",text:function(a){return a.i18n("buttons.pdf","PDF")},action:function(a,b,d,c){this.processing(!0);var a=c._flash,d=b.buttons.exportData(c.exportOptions),e=b.buttons.exportInfo(c),f=b.table().node().offsetWidth,g=b.columns(c.columns).indexes().map(function(a){return b.column(a).header().offsetWidth/f});a.setAction("pdf");a.setFileName(e.filename);t(a,JSON.stringify({title:e.title||"",messageTop:e.messageTop|| "",messageBottom:e.messageBottom||"",colWidth:g.toArray(),orientation:c.orientation,size:c.pageSize,header:c.header?d.header:null,footer:c.footer?d.footer:null,body:d.body}));this.processing(!1)},extension:".pdf",orientation:"portrait",pageSize:"A4",newline:"\n"});return h.Buttons}); PK ׁ�Z,�lϸ� �� js/dataTables.buttons.jsnu �[��� /*! Buttons for DataTables 1.6.5 * ©2016-2020 SpryMedia Ltd - datatables.net/license */ (function( factory ){ if ( typeof define === 'function' && define.amd ) { // AMD define( ['jquery', 'datatables.net'], function ( $ ) { return factory( $, window, document ); } ); } else if ( typeof exports === 'object' ) { // CommonJS module.exports = function (root, $) { if ( ! root ) { root = window; } if ( ! $ || ! $.fn.dataTable ) { $ = require('datatables.net')(root, $).$; } return factory( $, root, root.document ); }; } else { // Browser factory( jQuery, window, document ); } }(function( $, window, document, undefined ) { 'use strict'; var DataTable = $.fn.dataTable; // Used for namespacing events added to the document by each instance, so they // can be removed on destroy var _instCounter = 0; // Button namespacing counter for namespacing events on individual buttons var _buttonCounter = 0; var _dtButtons = DataTable.ext.buttons; // Allow for jQuery slim function _fadeIn(el, duration, fn) { if ($.fn.animate) { el .stop() .fadeIn( duration, fn ); } else { el.css('display', 'block'); if (fn) { fn.call(el); } } } function _fadeOut(el, duration, fn) { if ($.fn.animate) { el .stop() .fadeOut( duration, fn ); } else { el.css('display', 'none'); if (fn) { fn.call(el); } } } /** * [Buttons description] * @param {[type]} * @param {[type]} */ var Buttons = function( dt, config ) { // If not created with a `new` keyword then we return a wrapper function that // will take the settings object for a DT. This allows easy use of new instances // with the `layout` option - e.g. `topLeft: $.fn.dataTable.Buttons( ... )`. if ( !(this instanceof Buttons) ) { return function (settings) { return new Buttons( settings, dt ).container(); }; } // If there is no config set it to an empty object if ( typeof( config ) === 'undefined' ) { config = {}; } // Allow a boolean true for defaults if ( config === true ) { config = {}; } // For easy configuration of buttons an array can be given if ( Array.isArray( config ) ) { config = { buttons: config }; } this.c = $.extend( true, {}, Buttons.defaults, config ); // Don't want a deep copy for the buttons if ( config.buttons ) { this.c.buttons = config.buttons; } this.s = { dt: new DataTable.Api( dt ), buttons: [], listenKeys: '', namespace: 'dtb'+(_instCounter++) }; this.dom = { container: $('<'+this.c.dom.container.tag+'/>') .addClass( this.c.dom.container.className ) }; this._constructor(); }; $.extend( Buttons.prototype, { /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Public methods */ /** * Get the action of a button * @param {int|string} Button index * @return {function} *//** * Set the action of a button * @param {node} node Button element * @param {function} action Function to set * @return {Buttons} Self for chaining */ action: function ( node, action ) { var button = this._nodeToButton( node ); if ( action === undefined ) { return button.conf.action; } button.conf.action = action; return this; }, /** * Add an active class to the button to make to look active or get current * active state. * @param {node} node Button element * @param {boolean} [flag] Enable / disable flag * @return {Buttons} Self for chaining or boolean for getter */ active: function ( node, flag ) { var button = this._nodeToButton( node ); var klass = this.c.dom.button.active; var jqNode = $(button.node); if ( flag === undefined ) { return jqNode.hasClass( klass ); } jqNode.toggleClass( klass, flag === undefined ? true : flag ); return this; }, /** * Add a new button * @param {object} config Button configuration object, base string name or function * @param {int|string} [idx] Button index for where to insert the button * @return {Buttons} Self for chaining */ add: function ( config, idx ) { var buttons = this.s.buttons; if ( typeof idx === 'string' ) { var split = idx.split('-'); var base = this.s; for ( var i=0, ien=split.length-1 ; i<ien ; i++ ) { base = base.buttons[ split[i]*1 ]; } buttons = base.buttons; idx = split[ split.length-1 ]*1; } this._expandButton( buttons, config, base !== undefined, idx ); this._draw(); return this; }, /** * Get the container node for the buttons * @return {jQuery} Buttons node */ container: function () { return this.dom.container; }, /** * Disable a button * @param {node} node Button node * @return {Buttons} Self for chaining */ disable: function ( node ) { var button = this._nodeToButton( node ); $(button.node) .addClass( this.c.dom.button.disabled ) .attr('disabled', true); return this; }, /** * Destroy the instance, cleaning up event handlers and removing DOM * elements * @return {Buttons} Self for chaining */ destroy: function () { // Key event listener $('body').off( 'keyup.'+this.s.namespace ); // Individual button destroy (so they can remove their own events if // needed). Take a copy as the array is modified by `remove` var buttons = this.s.buttons.slice(); var i, ien; for ( i=0, ien=buttons.length ; i<ien ; i++ ) { this.remove( buttons[i].node ); } // Container this.dom.container.remove(); // Remove from the settings object collection var buttonInsts = this.s.dt.settings()[0]; for ( i=0, ien=buttonInsts.length ; i<ien ; i++ ) { if ( buttonInsts.inst === this ) { buttonInsts.splice( i, 1 ); break; } } return this; }, /** * Enable / disable a button * @param {node} node Button node * @param {boolean} [flag=true] Enable / disable flag * @return {Buttons} Self for chaining */ enable: function ( node, flag ) { if ( flag === false ) { return this.disable( node ); } var button = this._nodeToButton( node ); $(button.node) .removeClass( this.c.dom.button.disabled ) .removeAttr('disabled'); return this; }, /** * Get the instance name for the button set selector * @return {string} Instance name */ name: function () { return this.c.name; }, /** * Get a button's node of the buttons container if no button is given * @param {node} [node] Button node * @return {jQuery} Button element, or container */ node: function ( node ) { if ( ! node ) { return this.dom.container; } var button = this._nodeToButton( node ); return $(button.node); }, /** * Set / get a processing class on the selected button * @param {element} node Triggering button node * @param {boolean} flag true to add, false to remove, undefined to get * @return {boolean|Buttons} Getter value or this if a setter. */ processing: function ( node, flag ) { var dt = this.s.dt; var button = this._nodeToButton( node ); if ( flag === undefined ) { return $(button.node).hasClass( 'processing' ); } $(button.node).toggleClass( 'processing', flag ); $(dt.table().node()).triggerHandler( 'buttons-processing.dt', [ flag, dt.button( node ), dt, $(node), button.conf ] ); return this; }, /** * Remove a button. * @param {node} node Button node * @return {Buttons} Self for chaining */ remove: function ( node ) { var button = this._nodeToButton( node ); var host = this._nodeToHost( node ); var dt = this.s.dt; // Remove any child buttons first if ( button.buttons.length ) { for ( var i=button.buttons.length-1 ; i>=0 ; i-- ) { this.remove( button.buttons[i].node ); } } // Allow the button to remove event handlers, etc if ( button.conf.destroy ) { button.conf.destroy.call( dt.button(node), dt, $(node), button.conf ); } this._removeKey( button.conf ); $(button.node).remove(); var idx = $.inArray( button, host ); host.splice( idx, 1 ); return this; }, /** * Get the text for a button * @param {int|string} node Button index * @return {string} Button text *//** * Set the text for a button * @param {int|string|function} node Button index * @param {string} label Text * @return {Buttons} Self for chaining */ text: function ( node, label ) { var button = this._nodeToButton( node ); var buttonLiner = this.c.dom.collection.buttonLiner; var linerTag = button.inCollection && buttonLiner && buttonLiner.tag ? buttonLiner.tag : this.c.dom.buttonLiner.tag; var dt = this.s.dt; var jqNode = $(button.node); var text = function ( opt ) { return typeof opt === 'function' ? opt( dt, jqNode, button.conf ) : opt; }; if ( label === undefined ) { return text( button.conf.text ); } button.conf.text = label; if ( linerTag ) { jqNode.children( linerTag ).html( text(label) ); } else { jqNode.html( text(label) ); } return this; }, /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Constructor */ /** * Buttons constructor * @private */ _constructor: function () { var that = this; var dt = this.s.dt; var dtSettings = dt.settings()[0]; var buttons = this.c.buttons; if ( ! dtSettings._buttons ) { dtSettings._buttons = []; } dtSettings._buttons.push( { inst: this, name: this.c.name } ); for ( var i=0, ien=buttons.length ; i<ien ; i++ ) { this.add( buttons[i] ); } dt.on( 'destroy', function ( e, settings ) { if ( settings === dtSettings ) { that.destroy(); } } ); // Global key event binding to listen for button keys $('body').on( 'keyup.'+this.s.namespace, function ( e ) { if ( ! document.activeElement || document.activeElement === document.body ) { // SUse a string of characters for fast lookup of if we need to // handle this var character = String.fromCharCode(e.keyCode).toLowerCase(); if ( that.s.listenKeys.toLowerCase().indexOf( character ) !== -1 ) { that._keypress( character, e ); } } } ); }, /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Private methods */ /** * Add a new button to the key press listener * @param {object} conf Resolved button configuration object * @private */ _addKey: function ( conf ) { if ( conf.key ) { this.s.listenKeys += $.isPlainObject( conf.key ) ? conf.key.key : conf.key; } }, /** * Insert the buttons into the container. Call without parameters! * @param {node} [container] Recursive only - Insert point * @param {array} [buttons] Recursive only - Buttons array * @private */ _draw: function ( container, buttons ) { if ( ! container ) { container = this.dom.container; buttons = this.s.buttons; } container.children().detach(); for ( var i=0, ien=buttons.length ; i<ien ; i++ ) { container.append( buttons[i].inserter ); container.append( ' ' ); if ( buttons[i].buttons && buttons[i].buttons.length ) { this._draw( buttons[i].collection, buttons[i].buttons ); } } }, /** * Create buttons from an array of buttons * @param {array} attachTo Buttons array to attach to * @param {object} button Button definition * @param {boolean} inCollection true if the button is in a collection * @private */ _expandButton: function ( attachTo, button, inCollection, attachPoint ) { var dt = this.s.dt; var buttonCounter = 0; var buttons = ! Array.isArray( button ) ? [ button ] : button; for ( var i=0, ien=buttons.length ; i<ien ; i++ ) { var conf = this._resolveExtends( buttons[i] ); if ( ! conf ) { continue; } // If the configuration is an array, then expand the buttons at this // point if ( Array.isArray( conf ) ) { this._expandButton( attachTo, conf, inCollection, attachPoint ); continue; } var built = this._buildButton( conf, inCollection ); if ( ! built ) { continue; } if ( attachPoint !== undefined && attachPoint !== null ) { attachTo.splice( attachPoint, 0, built ); attachPoint++; } else { attachTo.push( built ); } if ( built.conf.buttons ) { built.collection = $('<'+this.c.dom.collection.tag+'/>'); built.conf._collection = built.collection; this._expandButton( built.buttons, built.conf.buttons, true, attachPoint ); } // init call is made here, rather than buildButton as it needs to // be selectable, and for that it needs to be in the buttons array if ( conf.init ) { conf.init.call( dt.button( built.node ), dt, $(built.node), conf ); } buttonCounter++; } }, /** * Create an individual button * @param {object} config Resolved button configuration * @param {boolean} inCollection `true` if a collection button * @return {jQuery} Created button node (jQuery) * @private */ _buildButton: function ( config, inCollection ) { var buttonDom = this.c.dom.button; var linerDom = this.c.dom.buttonLiner; var collectionDom = this.c.dom.collection; var dt = this.s.dt; var text = function ( opt ) { return typeof opt === 'function' ? opt( dt, button, config ) : opt; }; if ( inCollection && collectionDom.button ) { buttonDom = collectionDom.button; } if ( inCollection && collectionDom.buttonLiner ) { linerDom = collectionDom.buttonLiner; } // Make sure that the button is available based on whatever requirements // it has. For example, Flash buttons require Flash if ( config.available && ! config.available( dt, config ) ) { return false; } var action = function ( e, dt, button, config ) { config.action.call( dt.button( button ), e, dt, button, config ); $(dt.table().node()).triggerHandler( 'buttons-action.dt', [ dt.button( button ), dt, button, config ] ); }; var tag = config.tag || buttonDom.tag; var clickBlurs = config.clickBlurs === undefined ? true : config.clickBlurs var button = $('<'+tag+'/>') .addClass( buttonDom.className ) .attr( 'tabindex', this.s.dt.settings()[0].iTabIndex ) .attr( 'aria-controls', this.s.dt.table().node().id ) .on( 'click.dtb', function (e) { e.preventDefault(); if ( ! button.hasClass( buttonDom.disabled ) && config.action ) { action( e, dt, button, config ); } if( clickBlurs ) { button.trigger('blur'); } } ) .on( 'keyup.dtb', function (e) { if ( e.keyCode === 13 ) { if ( ! button.hasClass( buttonDom.disabled ) && config.action ) { action( e, dt, button, config ); } } } ); // Make `a` tags act like a link if ( tag.toLowerCase() === 'a' ) { button.attr( 'href', '#' ); } // Button tags should have `type=button` so they don't have any default behaviour if ( tag.toLowerCase() === 'button' ) { button.attr( 'type', 'button' ); } if ( linerDom.tag ) { var liner = $('<'+linerDom.tag+'/>') .html( text( config.text ) ) .addClass( linerDom.className ); if ( linerDom.tag.toLowerCase() === 'a' ) { liner.attr( 'href', '#' ); } button.append( liner ); } else { button.html( text( config.text ) ); } if ( config.enabled === false ) { button.addClass( buttonDom.disabled ); } if ( config.className ) { button.addClass( config.className ); } if ( config.titleAttr ) { button.attr( 'title', text( config.titleAttr ) ); } if ( config.attr ) { button.attr( config.attr ); } if ( ! config.namespace ) { config.namespace = '.dt-button-'+(_buttonCounter++); } var buttonContainer = this.c.dom.buttonContainer; var inserter; if ( buttonContainer && buttonContainer.tag ) { inserter = $('<'+buttonContainer.tag+'/>') .addClass( buttonContainer.className ) .append( button ); } else { inserter = button; } this._addKey( config ); // Style integration callback for DOM manipulation // Note that this is _not_ documented. It is currently // for style integration only if( this.c.buttonCreated ) { inserter = this.c.buttonCreated( config, inserter ); } return { conf: config, node: button.get(0), inserter: inserter, buttons: [], inCollection: inCollection, collection: null }; }, /** * Get the button object from a node (recursive) * @param {node} node Button node * @param {array} [buttons] Button array, uses base if not defined * @return {object} Button object * @private */ _nodeToButton: function ( node, buttons ) { if ( ! buttons ) { buttons = this.s.buttons; } for ( var i=0, ien=buttons.length ; i<ien ; i++ ) { if ( buttons[i].node === node ) { return buttons[i]; } if ( buttons[i].buttons.length ) { var ret = this._nodeToButton( node, buttons[i].buttons ); if ( ret ) { return ret; } } } }, /** * Get container array for a button from a button node (recursive) * @param {node} node Button node * @param {array} [buttons] Button array, uses base if not defined * @return {array} Button's host array * @private */ _nodeToHost: function ( node, buttons ) { if ( ! buttons ) { buttons = this.s.buttons; } for ( var i=0, ien=buttons.length ; i<ien ; i++ ) { if ( buttons[i].node === node ) { return buttons; } if ( buttons[i].buttons.length ) { var ret = this._nodeToHost( node, buttons[i].buttons ); if ( ret ) { return ret; } } } }, /** * Handle a key press - determine if any button's key configured matches * what was typed and trigger the action if so. * @param {string} character The character pressed * @param {object} e Key event that triggered this call * @private */ _keypress: function ( character, e ) { // Check if this button press already activated on another instance of Buttons if ( e._buttonsHandled ) { return; } var run = function ( conf, node ) { if ( ! conf.key ) { return; } if ( conf.key === character ) { e._buttonsHandled = true; $(node).click(); } else if ( $.isPlainObject( conf.key ) ) { if ( conf.key.key !== character ) { return; } if ( conf.key.shiftKey && ! e.shiftKey ) { return; } if ( conf.key.altKey && ! e.altKey ) { return; } if ( conf.key.ctrlKey && ! e.ctrlKey ) { return; } if ( conf.key.metaKey && ! e.metaKey ) { return; } // Made it this far - it is good e._buttonsHandled = true; $(node).click(); } }; var recurse = function ( a ) { for ( var i=0, ien=a.length ; i<ien ; i++ ) { run( a[i].conf, a[i].node ); if ( a[i].buttons.length ) { recurse( a[i].buttons ); } } }; recurse( this.s.buttons ); }, /** * Remove a key from the key listener for this instance (to be used when a * button is removed) * @param {object} conf Button configuration * @private */ _removeKey: function ( conf ) { if ( conf.key ) { var character = $.isPlainObject( conf.key ) ? conf.key.key : conf.key; // Remove only one character, as multiple buttons could have the // same listening key var a = this.s.listenKeys.split(''); var idx = $.inArray( character, a ); a.splice( idx, 1 ); this.s.listenKeys = a.join(''); } }, /** * Resolve a button configuration * @param {string|function|object} conf Button config to resolve * @return {object} Button configuration * @private */ _resolveExtends: function ( conf ) { var dt = this.s.dt; var i, ien; var toConfObject = function ( base ) { var loop = 0; // Loop until we have resolved to a button configuration, or an // array of button configurations (which will be iterated // separately) while ( ! $.isPlainObject(base) && ! Array.isArray(base) ) { if ( base === undefined ) { return; } if ( typeof base === 'function' ) { base = base( dt, conf ); if ( ! base ) { return false; } } else if ( typeof base === 'string' ) { if ( ! _dtButtons[ base ] ) { throw 'Unknown button type: '+base; } base = _dtButtons[ base ]; } loop++; if ( loop > 30 ) { // Protect against misconfiguration killing the browser throw 'Buttons: Too many iterations'; } } return Array.isArray( base ) ? base : $.extend( {}, base ); }; conf = toConfObject( conf ); while ( conf && conf.extend ) { // Use `toConfObject` in case the button definition being extended // is itself a string or a function if ( ! _dtButtons[ conf.extend ] ) { throw 'Cannot extend unknown button type: '+conf.extend; } var objArray = toConfObject( _dtButtons[ conf.extend ] ); if ( Array.isArray( objArray ) ) { return objArray; } else if ( ! objArray ) { // This is a little brutal as it might be possible to have a // valid button without the extend, but if there is no extend // then the host button would be acting in an undefined state return false; } // Stash the current class name var originalClassName = objArray.className; conf = $.extend( {}, objArray, conf ); // The extend will have overwritten the original class name if the // `conf` object also assigned a class, but we want to concatenate // them so they are list that is combined from all extended buttons if ( originalClassName && conf.className !== originalClassName ) { conf.className = originalClassName+' '+conf.className; } // Buttons to be added to a collection -gives the ability to define // if buttons should be added to the start or end of a collection var postfixButtons = conf.postfixButtons; if ( postfixButtons ) { if ( ! conf.buttons ) { conf.buttons = []; } for ( i=0, ien=postfixButtons.length ; i<ien ; i++ ) { conf.buttons.push( postfixButtons[i] ); } conf.postfixButtons = null; } var prefixButtons = conf.prefixButtons; if ( prefixButtons ) { if ( ! conf.buttons ) { conf.buttons = []; } for ( i=0, ien=prefixButtons.length ; i<ien ; i++ ) { conf.buttons.splice( i, 0, prefixButtons[i] ); } conf.prefixButtons = null; } // Although we want the `conf` object to overwrite almost all of // the properties of the object being extended, the `extend` // property should come from the object being extended conf.extend = objArray.extend; } return conf; }, /** * Display (and replace if there is an existing one) a popover attached to a button * @param {string|node} content Content to show * @param {DataTable.Api} hostButton DT API instance of the button * @param {object} inOpts Options (see object below for all options) */ _popover: function ( content, hostButton, inOpts ) { var dt = hostButton; var buttonsSettings = this.c; var options = $.extend( { align: 'button-left', // button-right, dt-container autoClose: false, background: true, backgroundClassName: 'dt-button-background', contentClassName: buttonsSettings.dom.collection.className, collectionLayout: '', collectionTitle: '', dropup: false, fade: 400, rightAlignClassName: 'dt-button-right', tag: buttonsSettings.dom.collection.tag }, inOpts ); var hostNode = hostButton.node(); var close = function () { _fadeOut( $('.dt-button-collection'), options.fade, function () { $(this).detach(); } ); $(dt.buttons( '[aria-haspopup="true"][aria-expanded="true"]' ).nodes()) .attr('aria-expanded', 'false'); $('div.dt-button-background').off( 'click.dtb-collection' ); Buttons.background( false, options.backgroundClassName, options.fade, hostNode ); $('body').off( '.dtb-collection' ); dt.off( 'buttons-action.b-internal' ); }; if (content === false) { close(); } var existingExpanded = $(dt.buttons( '[aria-haspopup="true"][aria-expanded="true"]' ).nodes()); if ( existingExpanded.length ) { hostNode = existingExpanded.eq(0); close(); } var display = $('<div/>') .addClass('dt-button-collection') .addClass(options.collectionLayout) .css('display', 'none'); content = $(content) .addClass(options.contentClassName) .attr('role', 'menu') .appendTo(display); hostNode.attr( 'aria-expanded', 'true' ); if ( hostNode.parents('body')[0] !== document.body ) { hostNode = document.body.lastChild; } if ( options.collectionTitle ) { display.prepend('<div class="dt-button-collection-title">'+options.collectionTitle+'</div>'); } _fadeIn( display.insertAfter( hostNode ), options.fade ); var tableContainer = $( hostButton.table().container() ); var position = display.css( 'position' ); if ( options.align === 'dt-container' ) { hostNode = hostNode.parent(); display.css('width', tableContainer.width()); } // Align the popover relative to the DataTables container // Useful for wide popovers such as SearchPanes if ( position === 'absolute' && ( display.hasClass( options.rightAlignClassName ) || display.hasClass( options.leftAlignClassName ) || options.align === 'dt-container' ) ) { var hostPosition = hostNode.position(); display.css( { top: hostPosition.top + hostNode.outerHeight(), left: hostPosition.left } ); // calculate overflow when positioned beneath var collectionHeight = display.outerHeight(); var tableBottom = tableContainer.offset().top + tableContainer.height(); var listBottom = hostPosition.top + hostNode.outerHeight() + collectionHeight; var bottomOverflow = listBottom - tableBottom; // calculate overflow when positioned above var listTop = hostPosition.top - collectionHeight; var tableTop = tableContainer.offset().top; var topOverflow = tableTop - listTop; // if bottom overflow is larger, move to the top because it fits better, or if dropup is requested var moveTop = hostPosition.top - collectionHeight - 5; if ( (bottomOverflow > topOverflow || options.dropup) && -moveTop < tableTop ) { display.css( 'top', moveTop); } // Get the size of the container (left and width - and thus also right) var tableLeft = tableContainer.offset().left; var tableWidth = tableContainer.width(); var tableRight = tableLeft + tableWidth; // Get the size of the popover (left and width - and ...) var popoverLeft = display.offset().left; var popoverWidth = display.width(); var popoverRight = popoverLeft + popoverWidth; // Get the size of the host buttons (left and width - and ...) var buttonsLeft = hostNode.offset().left; var buttonsWidth = hostNode.outerWidth() var buttonsRight = buttonsLeft + buttonsWidth; // You've then got all the numbers you need to do some calculations and if statements, // so we can do some quick JS maths and apply it only once // If it has the right align class OR the buttons are right aligned OR the button container is floated right, // then calculate left position for the popover to align the popover to the right hand // side of the button - check to see if the left of the popover is inside the table container. // If not, move the popover so it is, but not more than it means that the popover is to the right of the table container var popoverShuffle = 0; if ( display.hasClass( options.rightAlignClassName )) { popoverShuffle = buttonsRight - popoverRight; if(tableLeft > (popoverLeft + popoverShuffle)){ var leftGap = tableLeft - (popoverLeft + popoverShuffle); var rightGap = tableRight - (popoverRight + popoverShuffle); if(leftGap > rightGap){ popoverShuffle += rightGap; } else { popoverShuffle += leftGap; } } } // else attempt to left align the popover to the button. Similar to above, if the popover's right goes past the table container's right, // then move it back, but not so much that it goes past the left of the table container else { popoverShuffle = tableLeft - popoverLeft; if(tableRight < (popoverRight + popoverShuffle)){ var leftGap = tableLeft - (popoverLeft + popoverShuffle); var rightGap = tableRight - (popoverRight + popoverShuffle); if(leftGap > rightGap ){ popoverShuffle += rightGap; } else { popoverShuffle += leftGap; } } } display.css('left', display.position().left + popoverShuffle); } else if (position === 'absolute') { // Align relative to the host button var hostPosition = hostNode.position(); display.css( { top: hostPosition.top + hostNode.outerHeight(), left: hostPosition.left } ); // calculate overflow when positioned beneath var collectionHeight = display.outerHeight(); var top = hostNode.offset().top var popoverShuffle = 0; // Get the size of the host buttons (left and width - and ...) var buttonsLeft = hostNode.offset().left; var buttonsWidth = hostNode.outerWidth() var buttonsRight = buttonsLeft + buttonsWidth; // Get the size of the popover (left and width - and ...) var popoverLeft = display.offset().left; var popoverWidth = content.width(); var popoverRight = popoverLeft + popoverWidth; var moveTop = hostPosition.top - collectionHeight - 5; var tableBottom = tableContainer.offset().top + tableContainer.height(); var listBottom = hostPosition.top + hostNode.outerHeight() + collectionHeight; var bottomOverflow = listBottom - tableBottom; // calculate overflow when positioned above var listTop = hostPosition.top - collectionHeight; var tableTop = tableContainer.offset().top; var topOverflow = tableTop - listTop; if ( (bottomOverflow > topOverflow || options.dropup) && -moveTop < tableTop ) { display.css( 'top', moveTop); } popoverShuffle = options.align === 'button-right' ? buttonsRight - popoverRight : buttonsLeft - popoverLeft; display.css('left', display.position().left + popoverShuffle); } else { // Fix position - centre on screen var top = display.height() / 2; if ( top > $(window).height() / 2 ) { top = $(window).height() / 2; } display.css( 'marginTop', top*-1 ); } if ( options.background ) { Buttons.background( true, options.backgroundClassName, options.fade, hostNode ); } // This is bonkers, but if we don't have a click listener on the // background element, iOS Safari will ignore the body click // listener below. An empty function here is all that is // required to make it work... $('div.dt-button-background').on( 'click.dtb-collection', function () {} ); $('body') .on( 'click.dtb-collection', function (e) { // andSelf is deprecated in jQ1.8, but we want 1.7 compat var back = $.fn.addBack ? 'addBack' : 'andSelf'; var parent = $(e.target).parent()[0]; if (( ! $(e.target).parents()[back]().filter( content ).length && !$(parent).hasClass('dt-buttons')) || $(e.target).hasClass('dt-button-background')) { close(); } } ) .on( 'keyup.dtb-collection', function (e) { if ( e.keyCode === 27 ) { close(); } } ); if ( options.autoClose ) { setTimeout( function () { dt.on( 'buttons-action.b-internal', function (e, btn, dt, node) { if ( node[0] === hostNode[0] ) { return; } close(); } ); }, 0); } $(display).trigger('buttons-popover.dt'); } } ); /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Statics */ /** * Show / hide a background layer behind a collection * @param {boolean} Flag to indicate if the background should be shown or * hidden * @param {string} Class to assign to the background * @static */ Buttons.background = function ( show, className, fade, insertPoint ) { if ( fade === undefined ) { fade = 400; } if ( ! insertPoint ) { insertPoint = document.body; } if ( show ) { _fadeIn( $('<div/>') .addClass( className ) .css( 'display', 'none' ) .insertAfter( insertPoint ), fade ); } else { _fadeOut( $('div.'+className), fade, function () { $(this) .removeClass( className ) .remove(); } ); } }; /** * Instance selector - select Buttons instances based on an instance selector * value from the buttons assigned to a DataTable. This is only useful if * multiple instances are attached to a DataTable. * @param {string|int|array} Instance selector - see `instance-selector` * documentation on the DataTables site * @param {array} Button instance array that was attached to the DataTables * settings object * @return {array} Buttons instances * @static */ Buttons.instanceSelector = function ( group, buttons ) { if ( group === undefined || group === null ) { return $.map( buttons, function ( v ) { return v.inst; } ); } var ret = []; var names = $.map( buttons, function ( v ) { return v.name; } ); // Flatten the group selector into an array of single options var process = function ( input ) { if ( Array.isArray( input ) ) { for ( var i=0, ien=input.length ; i<ien ; i++ ) { process( input[i] ); } return; } if ( typeof input === 'string' ) { if ( input.indexOf( ',' ) !== -1 ) { // String selector, list of names process( input.split(',') ); } else { // String selector individual name var idx = $.inArray( input.trim(), names ); if ( idx !== -1 ) { ret.push( buttons[ idx ].inst ); } } } else if ( typeof input === 'number' ) { // Index selector ret.push( buttons[ input ].inst ); } }; process( group ); return ret; }; /** * Button selector - select one or more buttons from a selector input so some * operation can be performed on them. * @param {array} Button instances array that the selector should operate on * @param {string|int|node|jQuery|array} Button selector - see * `button-selector` documentation on the DataTables site * @return {array} Array of objects containing `inst` and `idx` properties of * the selected buttons so you know which instance each button belongs to. * @static */ Buttons.buttonSelector = function ( insts, selector ) { var ret = []; var nodeBuilder = function ( a, buttons, baseIdx ) { var button; var idx; for ( var i=0, ien=buttons.length ; i<ien ; i++ ) { button = buttons[i]; if ( button ) { idx = baseIdx !== undefined ? baseIdx+i : i+''; a.push( { node: button.node, name: button.conf.name, idx: idx } ); if ( button.buttons ) { nodeBuilder( a, button.buttons, idx+'-' ); } } } }; var run = function ( selector, inst ) { var i, ien; var buttons = []; nodeBuilder( buttons, inst.s.buttons ); var nodes = $.map( buttons, function (v) { return v.node; } ); if ( Array.isArray( selector ) || selector instanceof $ ) { for ( i=0, ien=selector.length ; i<ien ; i++ ) { run( selector[i], inst ); } return; } if ( selector === null || selector === undefined || selector === '*' ) { // Select all for ( i=0, ien=buttons.length ; i<ien ; i++ ) { ret.push( { inst: inst, node: buttons[i].node } ); } } else if ( typeof selector === 'number' ) { // Main button index selector ret.push( { inst: inst, node: inst.s.buttons[ selector ].node } ); } else if ( typeof selector === 'string' ) { if ( selector.indexOf( ',' ) !== -1 ) { // Split var a = selector.split(','); for ( i=0, ien=a.length ; i<ien ; i++ ) { run( a[i].trim(), inst ); } } else if ( selector.match( /^\d+(\-\d+)*$/ ) ) { // Sub-button index selector var indexes = $.map( buttons, function (v) { return v.idx; } ); ret.push( { inst: inst, node: buttons[ $.inArray( selector, indexes ) ].node } ); } else if ( selector.indexOf( ':name' ) !== -1 ) { // Button name selector var name = selector.replace( ':name', '' ); for ( i=0, ien=buttons.length ; i<ien ; i++ ) { if ( buttons[i].name === name ) { ret.push( { inst: inst, node: buttons[i].node } ); } } } else { // jQuery selector on the nodes $( nodes ).filter( selector ).each( function () { ret.push( { inst: inst, node: this } ); } ); } } else if ( typeof selector === 'object' && selector.nodeName ) { // Node selector var idx = $.inArray( selector, nodes ); if ( idx !== -1 ) { ret.push( { inst: inst, node: nodes[ idx ] } ); } } }; for ( var i=0, ien=insts.length ; i<ien ; i++ ) { var inst = insts[i]; run( selector, inst ); } return ret; }; /** * Buttons defaults. For full documentation, please refer to the docs/option * directory or the DataTables site. * @type {Object} * @static */ Buttons.defaults = { buttons: [ 'copy', 'excel', 'csv', 'pdf', 'print' ], name: 'main', tabIndex: 0, dom: { container: { tag: 'div', className: 'dt-buttons' }, collection: { tag: 'div', className: '' }, button: { // Flash buttons will not work with `<button>` in IE - it has to be `<a>` tag: 'ActiveXObject' in window ? 'a' : 'button', className: 'dt-button', active: 'active', disabled: 'disabled' }, buttonLiner: { tag: 'span', className: '' } } }; /** * Version information * @type {string} * @static */ Buttons.version = '1.6.5'; $.extend( _dtButtons, { collection: { text: function ( dt ) { return dt.i18n( 'buttons.collection', 'Collection' ); }, className: 'buttons-collection', init: function ( dt, button, config ) { button.attr( 'aria-expanded', false ); }, action: function ( e, dt, button, config ) { e.stopPropagation(); if ( config._collection.parents('body').length ) { this.popover(false, config); } else { this.popover(config._collection, config); } }, attr: { 'aria-haspopup': true } // Also the popover options, defined in Buttons.popover }, copy: function ( dt, conf ) { if ( _dtButtons.copyHtml5 ) { return 'copyHtml5'; } if ( _dtButtons.copyFlash && _dtButtons.copyFlash.available( dt, conf ) ) { return 'copyFlash'; } }, csv: function ( dt, conf ) { // Common option that will use the HTML5 or Flash export buttons if ( _dtButtons.csvHtml5 && _dtButtons.csvHtml5.available( dt, conf ) ) { return 'csvHtml5'; } if ( _dtButtons.csvFlash && _dtButtons.csvFlash.available( dt, conf ) ) { return 'csvFlash'; } }, excel: function ( dt, conf ) { // Common option that will use the HTML5 or Flash export buttons if ( _dtButtons.excelHtml5 && _dtButtons.excelHtml5.available( dt, conf ) ) { return 'excelHtml5'; } if ( _dtButtons.excelFlash && _dtButtons.excelFlash.available( dt, conf ) ) { return 'excelFlash'; } }, pdf: function ( dt, conf ) { // Common option that will use the HTML5 or Flash export buttons if ( _dtButtons.pdfHtml5 && _dtButtons.pdfHtml5.available( dt, conf ) ) { return 'pdfHtml5'; } if ( _dtButtons.pdfFlash && _dtButtons.pdfFlash.available( dt, conf ) ) { return 'pdfFlash'; } }, pageLength: function ( dt ) { var lengthMenu = dt.settings()[0].aLengthMenu; var vals = Array.isArray( lengthMenu[0] ) ? lengthMenu[0] : lengthMenu; var lang = Array.isArray( lengthMenu[0] ) ? lengthMenu[1] : lengthMenu; var text = function ( dt ) { return dt.i18n( 'buttons.pageLength', { "-1": 'Show all rows', _: 'Show %d rows' }, dt.page.len() ); }; return { extend: 'collection', text: text, className: 'buttons-page-length', autoClose: true, buttons: $.map( vals, function ( val, i ) { return { text: lang[i], className: 'button-page-length', action: function ( e, dt ) { dt.page.len( val ).draw(); }, init: function ( dt, node, conf ) { var that = this; var fn = function () { that.active( dt.page.len() === val ); }; dt.on( 'length.dt'+conf.namespace, fn ); fn(); }, destroy: function ( dt, node, conf ) { dt.off( 'length.dt'+conf.namespace ); } }; } ), init: function ( dt, node, conf ) { var that = this; dt.on( 'length.dt'+conf.namespace, function () { that.text( conf.text ); } ); }, destroy: function ( dt, node, conf ) { dt.off( 'length.dt'+conf.namespace ); } }; } } ); /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * DataTables API * * For complete documentation, please refer to the docs/api directory or the * DataTables site */ // Buttons group and individual button selector DataTable.Api.register( 'buttons()', function ( group, selector ) { // Argument shifting if ( selector === undefined ) { selector = group; group = undefined; } this.selector.buttonGroup = group; var res = this.iterator( true, 'table', function ( ctx ) { if ( ctx._buttons ) { return Buttons.buttonSelector( Buttons.instanceSelector( group, ctx._buttons ), selector ); } }, true ); res._groupSelector = group; return res; } ); // Individual button selector DataTable.Api.register( 'button()', function ( group, selector ) { // just run buttons() and truncate var buttons = this.buttons( group, selector ); if ( buttons.length > 1 ) { buttons.splice( 1, buttons.length ); } return buttons; } ); // Active buttons DataTable.Api.registerPlural( 'buttons().active()', 'button().active()', function ( flag ) { if ( flag === undefined ) { return this.map( function ( set ) { return set.inst.active( set.node ); } ); } return this.each( function ( set ) { set.inst.active( set.node, flag ); } ); } ); // Get / set button action DataTable.Api.registerPlural( 'buttons().action()', 'button().action()', function ( action ) { if ( action === undefined ) { return this.map( function ( set ) { return set.inst.action( set.node ); } ); } return this.each( function ( set ) { set.inst.action( set.node, action ); } ); } ); // Enable / disable buttons DataTable.Api.register( ['buttons().enable()', 'button().enable()'], function ( flag ) { return this.each( function ( set ) { set.inst.enable( set.node, flag ); } ); } ); // Disable buttons DataTable.Api.register( ['buttons().disable()', 'button().disable()'], function () { return this.each( function ( set ) { set.inst.disable( set.node ); } ); } ); // Get button nodes DataTable.Api.registerPlural( 'buttons().nodes()', 'button().node()', function () { var jq = $(); // jQuery will automatically reduce duplicates to a single entry $( this.each( function ( set ) { jq = jq.add( set.inst.node( set.node ) ); } ) ); return jq; } ); // Get / set button processing state DataTable.Api.registerPlural( 'buttons().processing()', 'button().processing()', function ( flag ) { if ( flag === undefined ) { return this.map( function ( set ) { return set.inst.processing( set.node ); } ); } return this.each( function ( set ) { set.inst.processing( set.node, flag ); } ); } ); // Get / set button text (i.e. the button labels) DataTable.Api.registerPlural( 'buttons().text()', 'button().text()', function ( label ) { if ( label === undefined ) { return this.map( function ( set ) { return set.inst.text( set.node ); } ); } return this.each( function ( set ) { set.inst.text( set.node, label ); } ); } ); // Trigger a button's action DataTable.Api.registerPlural( 'buttons().trigger()', 'button().trigger()', function () { return this.each( function ( set ) { set.inst.node( set.node ).trigger( 'click' ); } ); } ); // Button resolver to the popover DataTable.Api.register( 'button().popover()', function (content, options) { return this.map( function ( set ) { return set.inst._popover( content, this.button(this[0].node), options ); } ); } ); // Get the container elements DataTable.Api.register( 'buttons().containers()', function () { var jq = $(); var groupSelector = this._groupSelector; // We need to use the group selector directly, since if there are no buttons // the result set will be empty this.iterator( true, 'table', function ( ctx ) { if ( ctx._buttons ) { var insts = Buttons.instanceSelector( groupSelector, ctx._buttons ); for ( var i=0, ien=insts.length ; i<ien ; i++ ) { jq = jq.add( insts[i].container() ); } } } ); return jq; } ); DataTable.Api.register( 'buttons().container()', function () { // API level of nesting is `buttons()` so we can zip into the containers method return this.containers().eq(0); } ); // Add a new button DataTable.Api.register( 'button().add()', function ( idx, conf ) { var ctx = this.context; // Don't use `this` as it could be empty - select the instances directly if ( ctx.length ) { var inst = Buttons.instanceSelector( this._groupSelector, ctx[0]._buttons ); if ( inst.length ) { inst[0].add( conf, idx ); } } return this.button( this._groupSelector, idx ); } ); // Destroy the button sets selected DataTable.Api.register( 'buttons().destroy()', function () { this.pluck( 'inst' ).unique().each( function ( inst ) { inst.destroy(); } ); return this; } ); // Remove a button DataTable.Api.registerPlural( 'buttons().remove()', 'buttons().remove()', function () { this.each( function ( set ) { set.inst.remove( set.node ); } ); return this; } ); // Information box that can be used by buttons var _infoTimer; DataTable.Api.register( 'buttons.info()', function ( title, message, time ) { var that = this; if ( title === false ) { this.off('destroy.btn-info'); _fadeOut( $('#datatables_buttons_info'), 400, function () { $(this).remove(); } ); clearTimeout( _infoTimer ); _infoTimer = null; return this; } if ( _infoTimer ) { clearTimeout( _infoTimer ); } if ( $('#datatables_buttons_info').length ) { $('#datatables_buttons_info').remove(); } title = title ? '<h2>'+title+'</h2>' : ''; _fadeIn( $('<div id="datatables_buttons_info" class="dt-button-info"/>') .html( title ) .append( $('<div/>')[ typeof message === 'string' ? 'html' : 'append' ]( message ) ) .css( 'display', 'none' ) .appendTo( 'body' ) ); if ( time !== undefined && time !== 0 ) { _infoTimer = setTimeout( function () { that.buttons.info( false ); }, time ); } this.on('destroy.btn-info', function () { that.buttons.info(false); }); return this; } ); // Get data from the table for export - this is common to a number of plug-in // buttons so it is included in the Buttons core library DataTable.Api.register( 'buttons.exportData()', function ( options ) { if ( this.context.length ) { return _exportData( new DataTable.Api( this.context[0] ), options ); } } ); // Get information about the export that is common to many of the export data // types (DRY) DataTable.Api.register( 'buttons.exportInfo()', function ( conf ) { if ( ! conf ) { conf = {}; } return { filename: _filename( conf ), title: _title( conf ), messageTop: _message(this, conf.message || conf.messageTop, 'top'), messageBottom: _message(this, conf.messageBottom, 'bottom') }; } ); /** * Get the file name for an exported file. * * @param {object} config Button configuration * @param {boolean} incExtension Include the file name extension */ var _filename = function ( config ) { // Backwards compatibility var filename = config.filename === '*' && config.title !== '*' && config.title !== undefined && config.title !== null && config.title !== '' ? config.title : config.filename; if ( typeof filename === 'function' ) { filename = filename(); } if ( filename === undefined || filename === null ) { return null; } if ( filename.indexOf( '*' ) !== -1 ) { filename = filename.replace( '*', $('head > title').text() ).trim(); } // Strip characters which the OS will object to filename = filename.replace(/[^a-zA-Z0-9_\u00A1-\uFFFF\.,\-_ !\(\)]/g, ""); var extension = _stringOrFunction( config.extension ); if ( ! extension ) { extension = ''; } return filename + extension; }; /** * Simply utility method to allow parameters to be given as a function * * @param {undefined|string|function} option Option * @return {null|string} Resolved value */ var _stringOrFunction = function ( option ) { if ( option === null || option === undefined ) { return null; } else if ( typeof option === 'function' ) { return option(); } return option; }; /** * Get the title for an exported file. * * @param {object} config Button configuration */ var _title = function ( config ) { var title = _stringOrFunction( config.title ); return title === null ? null : title.indexOf( '*' ) !== -1 ? title.replace( '*', $('head > title').text() || 'Exported data' ) : title; }; var _message = function ( dt, option, position ) { var message = _stringOrFunction( option ); if ( message === null ) { return null; } var caption = $('caption', dt.table().container()).eq(0); if ( message === '*' ) { var side = caption.css( 'caption-side' ); if ( side !== position ) { return null; } return caption.length ? caption.text() : ''; } return message; }; var _exportTextarea = $('<textarea/>')[0]; var _exportData = function ( dt, inOpts ) { var config = $.extend( true, {}, { rows: null, columns: '', modifier: { search: 'applied', order: 'applied' }, orthogonal: 'display', stripHtml: true, stripNewlines: true, decodeEntities: true, trim: true, format: { header: function ( d ) { return strip( d ); }, footer: function ( d ) { return strip( d ); }, body: function ( d ) { return strip( d ); } }, customizeData: null }, inOpts ); var strip = function ( str ) { if ( typeof str !== 'string' ) { return str; } // Always remove script tags str = str.replace( /<script\b[^<]*(?:(?!<\/script>)<[^<]*)*<\/script>/gi, '' ); // Always remove comments str = str.replace( /<!\-\-.*?\-\->/g, '' ); if ( config.stripHtml ) { str = str.replace( /<([^>'"]*('[^']*'|"[^"]*")?)*>/g, '' ); } if ( config.trim ) { str = str.replace( /^\s+|\s+$/g, '' ); } if ( config.stripNewlines ) { str = str.replace( /\n/g, ' ' ); } if ( config.decodeEntities ) { _exportTextarea.innerHTML = str; str = _exportTextarea.value; } return str; }; var header = dt.columns( config.columns ).indexes().map( function (idx) { var el = dt.column( idx ).header(); return config.format.header( el.innerHTML, idx, el ); } ).toArray(); var footer = dt.table().footer() ? dt.columns( config.columns ).indexes().map( function (idx) { var el = dt.column( idx ).footer(); return config.format.footer( el ? el.innerHTML : '', idx, el ); } ).toArray() : null; // If Select is available on this table, and any rows are selected, limit the export // to the selected rows. If no rows are selected, all rows will be exported. Specify // a `selected` modifier to control directly. var modifier = $.extend( {}, config.modifier ); if ( dt.select && typeof dt.select.info === 'function' && modifier.selected === undefined ) { if ( dt.rows( config.rows, $.extend( { selected: true }, modifier ) ).any() ) { $.extend( modifier, { selected: true } ) } } var rowIndexes = dt.rows( config.rows, modifier ).indexes().toArray(); var selectedCells = dt.cells( rowIndexes, config.columns ); var cells = selectedCells .render( config.orthogonal ) .toArray(); var cellNodes = selectedCells .nodes() .toArray(); var columns = header.length; var rows = columns > 0 ? cells.length / columns : 0; var body = []; var cellCounter = 0; for ( var i=0, ien=rows ; i<ien ; i++ ) { var row = [ columns ]; for ( var j=0 ; j<columns ; j++ ) { row[j] = config.format.body( cells[ cellCounter ], i, j, cellNodes[ cellCounter ] ); cellCounter++; } body[i] = row; } var data = { header: header, footer: footer, body: body }; if ( config.customizeData ) { config.customizeData( data ); } return data; }; /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * DataTables interface */ // Attach to DataTables objects for global access $.fn.dataTable.Buttons = Buttons; $.fn.DataTable.Buttons = Buttons; // DataTables creation - check if the buttons have been defined for this table, // they will have been if the `B` option was used in `dom`, otherwise we should // create the buttons instance here so they can be inserted into the document // using the API. Listen for `init` for compatibility with pre 1.10.10, but to // be removed in future. $(document).on( 'init.dt plugin-init.dt', function (e, settings) { if ( e.namespace !== 'dt' ) { return; } var opts = settings.oInit.buttons || DataTable.defaults.buttons; if ( opts && ! settings._buttons ) { new Buttons( settings, opts ).container(); } } ); function _init ( settings, options ) { var api = new DataTable.Api( settings ); var opts = options ? options : api.init().buttons || DataTable.defaults.buttons; return new Buttons( api, opts ).container(); } // DataTables `dom` feature option DataTable.ext.feature.push( { fnInit: _init, cFeature: "B" } ); // DataTables 2 layout feature if ( DataTable.ext.features ) { DataTable.ext.features.register( 'buttons', _init ); } return Buttons; })); PK ׁ�Z1�R5� � js/buttons.print.jsnu �[��� /*! * Print button for Buttons and DataTables. * 2016 SpryMedia Ltd - datatables.net/license */ (function( factory ){ if ( typeof define === 'function' && define.amd ) { // AMD define( ['jquery', 'datatables.net', 'datatables.net-buttons'], function ( $ ) { return factory( $, window, document ); } ); } else if ( typeof exports === 'object' ) { // CommonJS module.exports = function (root, $) { if ( ! root ) { root = window; } if ( ! $ || ! $.fn.dataTable ) { $ = require('datatables.net')(root, $).$; } if ( ! $.fn.dataTable.Buttons ) { require('datatables.net-buttons')(root, $); } return factory( $, root, root.document ); }; } else { // Browser factory( jQuery, window, document ); } }(function( $, window, document, undefined ) { 'use strict'; var DataTable = $.fn.dataTable; var _link = document.createElement( 'a' ); /** * Clone link and style tags, taking into account the need to change the source * path. * * @param {node} el Element to convert */ var _styleToAbs = function( el ) { var url; var clone = $(el).clone()[0]; var linkHost; if ( clone.nodeName.toLowerCase() === 'link' ) { clone.href = _relToAbs( clone.href ); } return clone.outerHTML; }; /** * Convert a URL from a relative to an absolute address so it will work * correctly in the popup window which has no base URL. * * @param {string} href URL */ var _relToAbs = function( href ) { // Assign to a link on the original page so the browser will do all the // hard work of figuring out where the file actually is _link.href = href; var linkHost = _link.host; // IE doesn't have a trailing slash on the host // Chrome has it on the pathname if ( linkHost.indexOf('/') === -1 && _link.pathname.indexOf('/') !== 0) { linkHost += '/'; } return _link.protocol+"//"+linkHost+_link.pathname+_link.search; }; DataTable.ext.buttons.print = { className: 'buttons-print', text: function ( dt ) { return dt.i18n( 'buttons.print', 'Print' ); }, action: function ( e, dt, button, config ) { var data = dt.buttons.exportData( $.extend( {decodeEntities: false}, config.exportOptions ) // XSS protection ); var exportInfo = dt.buttons.exportInfo( config ); var columnClasses = dt .columns( config.exportOptions.columns ) .flatten() .map( function (idx) { return dt.settings()[0].aoColumns[dt.column(idx).index()].sClass; } ) .toArray(); var addRow = function ( d, tag ) { var str = '<tr>'; for ( var i=0, ien=d.length ; i<ien ; i++ ) { // null and undefined aren't useful in the print output var dataOut = d[i] === null || d[i] === undefined ? '' : d[i]; var classAttr = columnClasses[i] ? 'class="'+columnClasses[i]+'"' : ''; str += '<'+tag+' '+classAttr+'>'+dataOut+'</'+tag+'>'; } return str + '</tr>'; }; // Construct a table for printing var html = '<table class="'+dt.table().node().className+'">'; if ( config.header ) { html += '<thead>'+ addRow( data.header, 'th' ) +'</thead>'; } html += '<tbody>'; for ( var i=0, ien=data.body.length ; i<ien ; i++ ) { html += addRow( data.body[i], 'td' ); } html += '</tbody>'; if ( config.footer && data.footer ) { html += '<tfoot>'+ addRow( data.footer, 'th' ) +'</tfoot>'; } html += '</table>'; // Open a new window for the printable table var win = window.open( '', '' ); win.document.close(); // Inject the title and also a copy of the style and link tags from this // document so the table can retain its base styling. Note that we have // to use string manipulation as IE won't allow elements to be created // in the host document and then appended to the new window. var head = '<title>'+exportInfo.title+'</title>'; $('style, link').each( function () { head += _styleToAbs( this ); } ); try { win.document.head.innerHTML = head; // Work around for Edge } catch (e) { $(win.document.head).html( head ); // Old IE } // Inject the table and other surrounding information win.document.body.innerHTML = '<h1>'+exportInfo.title+'</h1>'+ '<div>'+(exportInfo.messageTop || '')+'</div>'+ html+ '<div>'+(exportInfo.messageBottom || '')+'</div>'; $(win.document.body).addClass('dt-print-view'); $('img', win.document.body).each( function ( i, img ) { img.setAttribute( 'src', _relToAbs( img.getAttribute('src') ) ); } ); if ( config.customize ) { config.customize( win, config, dt ); } // Allow stylesheets time to load var autoPrint = function () { if ( config.autoPrint ) { win.print(); // blocking - so close will not win.close(); // execute until this is done } }; if ( navigator.userAgent.match(/Trident\/\d.\d/) ) { // IE needs to call this without a setTimeout autoPrint(); } else { win.setTimeout( autoPrint, 1000 ); } }, title: '*', messageTop: '*', messageBottom: '*', exportOptions: {}, header: true, footer: false, autoPrint: true, customize: null }; return DataTable.Buttons; })); PK ׁ�Z[x��O �O js/dataTables.buttons.min.jsnu �[��� /*! Buttons for DataTables 1.6.5 ©2016-2020 SpryMedia Ltd - datatables.net/license */ (function(e){"function"===typeof define&&define.amd?define(["jquery","datatables.net"],function(q){return e(q,window,document)}):"object"===typeof exports?module.exports=function(q,r){q||(q=window);if(!r||!r.fn.dataTable)r=require("datatables.net")(q,r).$;return e(r,q,q.document)}:e(jQuery,window,document)})(function(e,q,r,m){function w(a,b,c){e.fn.animate?a.stop().fadeIn(b,c):(a.css("display","block"),c&&c.call(a))}function x(a,b,c){e.fn.animate?a.stop().fadeOut(b,c):(a.css("display","none"),c&& c.call(a))}function z(a,b){var c=new i.Api(a),d=b?b:c.init().buttons||i.defaults.buttons;return(new p(c,d)).container()}var i=e.fn.dataTable,C=0,D=0,l=i.ext.buttons,p=function(a,b){if(!(this instanceof p))return function(b){return(new p(b,a)).container()};"undefined"===typeof b&&(b={});!0===b&&(b={});Array.isArray(b)&&(b={buttons:b});this.c=e.extend(!0,{},p.defaults,b);b.buttons&&(this.c.buttons=b.buttons);this.s={dt:new i.Api(a),buttons:[],listenKeys:"",namespace:"dtb"+C++};this.dom={container:e("<"+ this.c.dom.container.tag+"/>").addClass(this.c.dom.container.className)};this._constructor()};e.extend(p.prototype,{action:function(a,b){var c=this._nodeToButton(a);if(b===m)return c.conf.action;c.conf.action=b;return this},active:function(a,b){var c=this._nodeToButton(a),d=this.c.dom.button.active,c=e(c.node);if(b===m)return c.hasClass(d);c.toggleClass(d,b===m?!0:b);return this},add:function(a,b){var c=this.s.buttons;if("string"===typeof b){for(var d=b.split("-"),e=this.s,c=0,f=d.length-1;c<f;c++)e= e.buttons[1*d[c]];c=e.buttons;b=1*d[d.length-1]}this._expandButton(c,a,e!==m,b);this._draw();return this},container:function(){return this.dom.container},disable:function(a){a=this._nodeToButton(a);e(a.node).addClass(this.c.dom.button.disabled).attr("disabled",!0);return this},destroy:function(){e("body").off("keyup."+this.s.namespace);var a=this.s.buttons.slice(),b,c;b=0;for(c=a.length;b<c;b++)this.remove(a[b].node);this.dom.container.remove();a=this.s.dt.settings()[0];b=0;for(c=a.length;b<c;b++)if(a.inst=== this){a.splice(b,1);break}return this},enable:function(a,b){if(!1===b)return this.disable(a);var c=this._nodeToButton(a);e(c.node).removeClass(this.c.dom.button.disabled).removeAttr("disabled");return this},name:function(){return this.c.name},node:function(a){if(!a)return this.dom.container;a=this._nodeToButton(a);return e(a.node)},processing:function(a,b){var c=this.s.dt,d=this._nodeToButton(a);if(b===m)return e(d.node).hasClass("processing");e(d.node).toggleClass("processing",b);e(c.table().node()).triggerHandler("buttons-processing.dt", [b,c.button(a),c,e(a),d.conf]);return this},remove:function(a){var b=this._nodeToButton(a),c=this._nodeToHost(a),d=this.s.dt;if(b.buttons.length)for(var g=b.buttons.length-1;0<=g;g--)this.remove(b.buttons[g].node);b.conf.destroy&&b.conf.destroy.call(d.button(a),d,e(a),b.conf);this._removeKey(b.conf);e(b.node).remove();a=e.inArray(b,c);c.splice(a,1);return this},text:function(a,b){var c=this._nodeToButton(a),d=this.c.dom.collection.buttonLiner,d=c.inCollection&&d&&d.tag?d.tag:this.c.dom.buttonLiner.tag, g=this.s.dt,f=e(c.node),h=function(a){return"function"===typeof a?a(g,f,c.conf):a};if(b===m)return h(c.conf.text);c.conf.text=b;d?f.children(d).html(h(b)):f.html(h(b));return this},_constructor:function(){var a=this,b=this.s.dt,c=b.settings()[0],d=this.c.buttons;c._buttons||(c._buttons=[]);c._buttons.push({inst:this,name:this.c.name});for(var g=0,f=d.length;g<f;g++)this.add(d[g]);b.on("destroy",function(b,d){d===c&&a.destroy()});e("body").on("keyup."+this.s.namespace,function(b){if(!r.activeElement|| r.activeElement===r.body){var c=String.fromCharCode(b.keyCode).toLowerCase();a.s.listenKeys.toLowerCase().indexOf(c)!==-1&&a._keypress(c,b)}})},_addKey:function(a){a.key&&(this.s.listenKeys+=e.isPlainObject(a.key)?a.key.key:a.key)},_draw:function(a,b){a||(a=this.dom.container,b=this.s.buttons);a.children().detach();for(var c=0,d=b.length;c<d;c++)a.append(b[c].inserter),a.append(" "),b[c].buttons&&b[c].buttons.length&&this._draw(b[c].collection,b[c].buttons)},_expandButton:function(a,b,c,d){for(var g= this.s.dt,f=0,b=!Array.isArray(b)?[b]:b,h=0,k=b.length;h<k;h++){var n=this._resolveExtends(b[h]);if(n)if(Array.isArray(n))this._expandButton(a,n,c,d);else{var j=this._buildButton(n,c);j&&(d!==m&&null!==d?(a.splice(d,0,j),d++):a.push(j),j.conf.buttons&&(j.collection=e("<"+this.c.dom.collection.tag+"/>"),j.conf._collection=j.collection,this._expandButton(j.buttons,j.conf.buttons,!0,d)),n.init&&n.init.call(g.button(j.node),g,e(j.node),n),f++)}}},_buildButton:function(a,b){var c=this.c.dom.button,d=this.c.dom.buttonLiner, g=this.c.dom.collection,f=this.s.dt,h=function(b){return"function"===typeof b?b(f,j,a):b};b&&g.button&&(c=g.button);b&&g.buttonLiner&&(d=g.buttonLiner);if(a.available&&!a.available(f,a))return!1;var k=function(a,b,c,d){d.action.call(b.button(c),a,b,c,d);e(b.table().node()).triggerHandler("buttons-action.dt",[b.button(c),b,c,d])},g=a.tag||c.tag,n=a.clickBlurs===m?!0:a.clickBlurs,j=e("<"+g+"/>").addClass(c.className).attr("tabindex",this.s.dt.settings()[0].iTabIndex).attr("aria-controls",this.s.dt.table().node().id).on("click.dtb", function(b){b.preventDefault();!j.hasClass(c.disabled)&&a.action&&k(b,f,j,a);n&&j.trigger("blur")}).on("keyup.dtb",function(b){b.keyCode===13&&!j.hasClass(c.disabled)&&a.action&&k(b,f,j,a)});"a"===g.toLowerCase()&&j.attr("href","#");"button"===g.toLowerCase()&&j.attr("type","button");d.tag?(g=e("<"+d.tag+"/>").html(h(a.text)).addClass(d.className),"a"===d.tag.toLowerCase()&&g.attr("href","#"),j.append(g)):j.html(h(a.text));!1===a.enabled&&j.addClass(c.disabled);a.className&&j.addClass(a.className); a.titleAttr&&j.attr("title",h(a.titleAttr));a.attr&&j.attr(a.attr);a.namespace||(a.namespace=".dt-button-"+D++);d=(d=this.c.dom.buttonContainer)&&d.tag?e("<"+d.tag+"/>").addClass(d.className).append(j):j;this._addKey(a);this.c.buttonCreated&&(d=this.c.buttonCreated(a,d));return{conf:a,node:j.get(0),inserter:d,buttons:[],inCollection:b,collection:null}},_nodeToButton:function(a,b){b||(b=this.s.buttons);for(var c=0,d=b.length;c<d;c++){if(b[c].node===a)return b[c];if(b[c].buttons.length){var e=this._nodeToButton(a, b[c].buttons);if(e)return e}}},_nodeToHost:function(a,b){b||(b=this.s.buttons);for(var c=0,d=b.length;c<d;c++){if(b[c].node===a)return b;if(b[c].buttons.length){var e=this._nodeToHost(a,b[c].buttons);if(e)return e}}},_keypress:function(a,b){if(!b._buttonsHandled){var c=function(d){for(var g=0,f=d.length;g<f;g++){var h=d[g].conf,k=d[g].node;if(h.key)if(h.key===a)b._buttonsHandled=!0,e(k).click();else if(e.isPlainObject(h.key)&&h.key.key===a&&(!h.key.shiftKey||b.shiftKey))if(!h.key.altKey||b.altKey)if(!h.key.ctrlKey|| b.ctrlKey)if(!h.key.metaKey||b.metaKey)b._buttonsHandled=!0,e(k).click();d[g].buttons.length&&c(d[g].buttons)}};c(this.s.buttons)}},_removeKey:function(a){if(a.key){var b=e.isPlainObject(a.key)?a.key.key:a.key,a=this.s.listenKeys.split(""),b=e.inArray(b,a);a.splice(b,1);this.s.listenKeys=a.join("")}},_resolveExtends:function(a){for(var b=this.s.dt,c,d,g=function(c){for(var d=0;!e.isPlainObject(c)&&!Array.isArray(c);){if(c===m)return;if("function"===typeof c){if(c=c(b,a),!c)return!1}else if("string"=== typeof c){if(!l[c])throw"Unknown button type: "+c;c=l[c]}d++;if(30<d)throw"Buttons: Too many iterations";}return Array.isArray(c)?c:e.extend({},c)},a=g(a);a&&a.extend;){if(!l[a.extend])throw"Cannot extend unknown button type: "+a.extend;var f=g(l[a.extend]);if(Array.isArray(f))return f;if(!f)return!1;c=f.className;a=e.extend({},f,a);c&&a.className!==c&&(a.className=c+" "+a.className);var h=a.postfixButtons;if(h){a.buttons||(a.buttons=[]);c=0;for(d=h.length;c<d;c++)a.buttons.push(h[c]);a.postfixButtons= null}if(h=a.prefixButtons){a.buttons||(a.buttons=[]);c=0;for(d=h.length;c<d;c++)a.buttons.splice(c,0,h[c]);a.prefixButtons=null}a.extend=f.extend}return a},_popover:function(a,b,c){var d=this.c,g=e.extend({align:"button-left",autoClose:!1,background:!0,backgroundClassName:"dt-button-background",contentClassName:d.dom.collection.className,collectionLayout:"",collectionTitle:"",dropup:!1,fade:400,rightAlignClassName:"dt-button-right",tag:d.dom.collection.tag},c),f=b.node(),h=function(){x(e(".dt-button-collection"), g.fade,function(){e(this).detach()});e(b.buttons('[aria-haspopup="true"][aria-expanded="true"]').nodes()).attr("aria-expanded","false");e("div.dt-button-background").off("click.dtb-collection");p.background(!1,g.backgroundClassName,g.fade,f);e("body").off(".dtb-collection");b.off("buttons-action.b-internal")};!1===a&&h();c=e(b.buttons('[aria-haspopup="true"][aria-expanded="true"]').nodes());c.length&&(f=c.eq(0),h());c=e("<div/>").addClass("dt-button-collection").addClass(g.collectionLayout).css("display", "none");a=e(a).addClass(g.contentClassName).attr("role","menu").appendTo(c);f.attr("aria-expanded","true");f.parents("body")[0]!==r.body&&(f=r.body.lastChild);g.collectionTitle&&c.prepend('<div class="dt-button-collection-title">'+g.collectionTitle+"</div>");w(c.insertAfter(f),g.fade);var d=e(b.table().container()),k=c.css("position");"dt-container"===g.align&&(f=f.parent(),c.css("width",d.width()));if("absolute"===k&&(c.hasClass(g.rightAlignClassName)||c.hasClass(g.leftAlignClassName)||"dt-container"=== g.align)){var n=f.position();c.css({top:n.top+f.outerHeight(),left:n.left});var j=c.outerHeight(),i=d.offset().top+d.height(),t=n.top+f.outerHeight()+j,i=t-i,t=n.top-j,m=d.offset().top,l=n.top-j-5;(i>m-t||g.dropup)&&-l<m&&c.css("top",l);var n=d.offset().left,d=d.width(),d=n+d,k=c.offset().left,s=c.width(),s=k+s,o=f.offset().left,u=f.outerWidth(),u=o+u,o=0;c.hasClass(g.rightAlignClassName)?(o=u-s,n>k+o&&(k=n-(k+o),d-=s+o,o=k>d?o+d:o+k)):(o=n-k,d<s+o&&(k=n-(k+o),d-=s+o,o=k>d?o+d:o+k));c.css("left", c.position().left+o)}else"absolute"===k?(n=f.position(),c.css({top:n.top+f.outerHeight(),left:n.left}),j=c.outerHeight(),k=f.offset().top,o=0,o=f.offset().left,u=f.outerWidth(),u=o+u,k=c.offset().left,s=a.width(),s=k+s,l=n.top-j-5,i=d.offset().top+d.height(),t=n.top+f.outerHeight()+j,i=t-i,t=n.top-j,m=d.offset().top,(i>m-t||g.dropup)&&-l<m&&c.css("top",l),o="button-right"===g.align?u-s:o-k,c.css("left",c.position().left+o)):(k=c.height()/2,k>e(q).height()/2&&(k=e(q).height()/2),c.css("marginTop", -1*k));g.background&&p.background(!0,g.backgroundClassName,g.fade,f);e("div.dt-button-background").on("click.dtb-collection",function(){});e("body").on("click.dtb-collection",function(b){var c=e.fn.addBack?"addBack":"andSelf",d=e(b.target).parent()[0];(!e(b.target).parents()[c]().filter(a).length&&!e(d).hasClass("dt-buttons")||e(b.target).hasClass("dt-button-background"))&&h()}).on("keyup.dtb-collection",function(a){a.keyCode===27&&h()});g.autoClose&&setTimeout(function(){b.on("buttons-action.b-internal", function(a,b,c,d){d[0]!==f[0]&&h()})},0);e(c).trigger("buttons-popover.dt")}});p.background=function(a,b,c,d){c===m&&(c=400);d||(d=r.body);a?w(e("<div/>").addClass(b).css("display","none").insertAfter(d),c):x(e("div."+b),c,function(){e(this).removeClass(b).remove()})};p.instanceSelector=function(a,b){if(a===m||null===a)return e.map(b,function(a){return a.inst});var c=[],d=e.map(b,function(a){return a.name}),g=function(a){if(Array.isArray(a))for(var h=0,k=a.length;h<k;h++)g(a[h]);else"string"===typeof a? -1!==a.indexOf(",")?g(a.split(",")):(a=e.inArray(a.trim(),d),-1!==a&&c.push(b[a].inst)):"number"===typeof a&&c.push(b[a].inst)};g(a);return c};p.buttonSelector=function(a,b){for(var c=[],d=function(a,b,c){for(var e,g,f=0,h=b.length;f<h;f++)if(e=b[f])g=c!==m?c+f:f+"",a.push({node:e.node,name:e.conf.name,idx:g}),e.buttons&&d(a,e.buttons,g+"-")},g=function(a,b){var f,h,i=[];d(i,b.s.buttons);f=e.map(i,function(a){return a.node});if(Array.isArray(a)||a instanceof e){f=0;for(h=a.length;f<h;f++)g(a[f],b)}else if(null=== a||a===m||"*"===a){f=0;for(h=i.length;f<h;f++)c.push({inst:b,node:i[f].node})}else if("number"===typeof a)c.push({inst:b,node:b.s.buttons[a].node});else if("string"===typeof a)if(-1!==a.indexOf(",")){i=a.split(",");f=0;for(h=i.length;f<h;f++)g(i[f].trim(),b)}else if(a.match(/^\d+(\-\d+)*$/))f=e.map(i,function(a){return a.idx}),c.push({inst:b,node:i[e.inArray(a,f)].node});else if(-1!==a.indexOf(":name")){var l=a.replace(":name","");f=0;for(h=i.length;f<h;f++)i[f].name===l&&c.push({inst:b,node:i[f].node})}else e(f).filter(a).each(function(){c.push({inst:b, node:this})});else"object"===typeof a&&a.nodeName&&(i=e.inArray(a,f),-1!==i&&c.push({inst:b,node:f[i]}))},f=0,h=a.length;f<h;f++)g(b,a[f]);return c};p.defaults={buttons:["copy","excel","csv","pdf","print"],name:"main",tabIndex:0,dom:{container:{tag:"div",className:"dt-buttons"},collection:{tag:"div",className:""},button:{tag:"ActiveXObject"in q?"a":"button",className:"dt-button",active:"active",disabled:"disabled"},buttonLiner:{tag:"span",className:""}}};p.version="1.6.5";e.extend(l,{collection:{text:function(a){return a.i18n("buttons.collection", "Collection")},className:"buttons-collection",init:function(a,b){b.attr("aria-expanded",!1)},action:function(a,b,c,d){a.stopPropagation();d._collection.parents("body").length?this.popover(!1,d):this.popover(d._collection,d)},attr:{"aria-haspopup":!0}},copy:function(a,b){if(l.copyHtml5)return"copyHtml5";if(l.copyFlash&&l.copyFlash.available(a,b))return"copyFlash"},csv:function(a,b){if(l.csvHtml5&&l.csvHtml5.available(a,b))return"csvHtml5";if(l.csvFlash&&l.csvFlash.available(a,b))return"csvFlash"}, excel:function(a,b){if(l.excelHtml5&&l.excelHtml5.available(a,b))return"excelHtml5";if(l.excelFlash&&l.excelFlash.available(a,b))return"excelFlash"},pdf:function(a,b){if(l.pdfHtml5&&l.pdfHtml5.available(a,b))return"pdfHtml5";if(l.pdfFlash&&l.pdfFlash.available(a,b))return"pdfFlash"},pageLength:function(a){var a=a.settings()[0].aLengthMenu,b=Array.isArray(a[0])?a[0]:a,c=Array.isArray(a[0])?a[1]:a;return{extend:"collection",text:function(a){return a.i18n("buttons.pageLength",{"-1":"Show all rows",_:"Show %d rows"}, a.page.len())},className:"buttons-page-length",autoClose:!0,buttons:e.map(b,function(a,b){return{text:c[b],className:"button-page-length",action:function(b,c){c.page.len(a).draw()},init:function(b,c,e){var g=this,c=function(){g.active(b.page.len()===a)};b.on("length.dt"+e.namespace,c);c()},destroy:function(a,b,c){a.off("length.dt"+c.namespace)}}}),init:function(a,b,c){var e=this;a.on("length.dt"+c.namespace,function(){e.text(c.text)})},destroy:function(a,b,c){a.off("length.dt"+c.namespace)}}}});i.Api.register("buttons()", function(a,b){b===m&&(b=a,a=m);this.selector.buttonGroup=a;var c=this.iterator(!0,"table",function(c){if(c._buttons)return p.buttonSelector(p.instanceSelector(a,c._buttons),b)},!0);c._groupSelector=a;return c});i.Api.register("button()",function(a,b){var c=this.buttons(a,b);1<c.length&&c.splice(1,c.length);return c});i.Api.registerPlural("buttons().active()","button().active()",function(a){return a===m?this.map(function(a){return a.inst.active(a.node)}):this.each(function(b){b.inst.active(b.node, a)})});i.Api.registerPlural("buttons().action()","button().action()",function(a){return a===m?this.map(function(a){return a.inst.action(a.node)}):this.each(function(b){b.inst.action(b.node,a)})});i.Api.register(["buttons().enable()","button().enable()"],function(a){return this.each(function(b){b.inst.enable(b.node,a)})});i.Api.register(["buttons().disable()","button().disable()"],function(){return this.each(function(a){a.inst.disable(a.node)})});i.Api.registerPlural("buttons().nodes()","button().node()", function(){var a=e();e(this.each(function(b){a=a.add(b.inst.node(b.node))}));return a});i.Api.registerPlural("buttons().processing()","button().processing()",function(a){return a===m?this.map(function(a){return a.inst.processing(a.node)}):this.each(function(b){b.inst.processing(b.node,a)})});i.Api.registerPlural("buttons().text()","button().text()",function(a){return a===m?this.map(function(a){return a.inst.text(a.node)}):this.each(function(b){b.inst.text(b.node,a)})});i.Api.registerPlural("buttons().trigger()", "button().trigger()",function(){return this.each(function(a){a.inst.node(a.node).trigger("click")})});i.Api.register("button().popover()",function(a,b){return this.map(function(c){return c.inst._popover(a,this.button(this[0].node),b)})});i.Api.register("buttons().containers()",function(){var a=e(),b=this._groupSelector;this.iterator(!0,"table",function(c){if(c._buttons)for(var c=p.instanceSelector(b,c._buttons),d=0,e=c.length;d<e;d++)a=a.add(c[d].container())});return a});i.Api.register("buttons().container()", function(){return this.containers().eq(0)});i.Api.register("button().add()",function(a,b){var c=this.context;c.length&&(c=p.instanceSelector(this._groupSelector,c[0]._buttons),c.length&&c[0].add(b,a));return this.button(this._groupSelector,a)});i.Api.register("buttons().destroy()",function(){this.pluck("inst").unique().each(function(a){a.destroy()});return this});i.Api.registerPlural("buttons().remove()","buttons().remove()",function(){this.each(function(a){a.inst.remove(a.node)});return this});var v; i.Api.register("buttons.info()",function(a,b,c){var d=this;if(!1===a)return this.off("destroy.btn-info"),x(e("#datatables_buttons_info"),400,function(){e(this).remove()}),clearTimeout(v),v=null,this;v&&clearTimeout(v);e("#datatables_buttons_info").length&&e("#datatables_buttons_info").remove();w(e('<div id="datatables_buttons_info" class="dt-button-info"/>').html(a?"<h2>"+a+"</h2>":"").append(e("<div/>")["string"===typeof b?"html":"append"](b)).css("display","none").appendTo("body"));c!==m&&0!==c&& (v=setTimeout(function(){d.buttons.info(!1)},c));this.on("destroy.btn-info",function(){d.buttons.info(!1)});return this});i.Api.register("buttons.exportData()",function(a){if(this.context.length){var b=new i.Api(this.context[0]),c=e.extend(!0,{},{rows:null,columns:"",modifier:{search:"applied",order:"applied"},orthogonal:"display",stripHtml:!0,stripNewlines:!0,decodeEntities:!0,trim:!0,format:{header:function(a){return d(a)},footer:function(a){return d(a)},body:function(a){return d(a)}},customizeData:null}, a),d=function(a){if("string"!==typeof a)return a;a=a.replace(/<script\b[^<]*(?:(?!<\/script>)<[^<]*)*<\/script>/gi,"");a=a.replace(/<!\-\-.*?\-\->/g,"");c.stripHtml&&(a=a.replace(/<([^>'"]*('[^']*'|"[^"]*")?)*>/g,""));c.trim&&(a=a.replace(/^\s+|\s+$/g,""));c.stripNewlines&&(a=a.replace(/\n/g," "));c.decodeEntities&&(A.innerHTML=a,a=A.value);return a},a=b.columns(c.columns).indexes().map(function(a){var d=b.column(a).header();return c.format.header(d.innerHTML,a,d)}).toArray(),g=b.table().footer()? b.columns(c.columns).indexes().map(function(a){var d=b.column(a).footer();return c.format.footer(d?d.innerHTML:"",a,d)}).toArray():null,f=e.extend({},c.modifier);b.select&&"function"===typeof b.select.info&&f.selected===m&&b.rows(c.rows,e.extend({selected:!0},f)).any()&&e.extend(f,{selected:!0});for(var f=b.rows(c.rows,f).indexes().toArray(),h=b.cells(f,c.columns),f=h.render(c.orthogonal).toArray(),h=h.nodes().toArray(),k=a.length,n=[],j=0,l=0,p=0<k?f.length/k:0;l<p;l++){for(var r=[k],q=0;q<k;q++)r[q]= c.format.body(f[j],l,q,h[j]),j++;n[l]=r}a={header:a,footer:g,body:n};c.customizeData&&c.customizeData(a);return a}});i.Api.register("buttons.exportInfo()",function(a){a||(a={});var b;var c=a;b="*"===c.filename&&"*"!==c.title&&c.title!==m&&null!==c.title&&""!==c.title?c.title:c.filename;"function"===typeof b&&(b=b());b===m||null===b?b=null:(-1!==b.indexOf("*")&&(b=b.replace("*",e("head > title").text()).trim()),b=b.replace(/[^a-zA-Z0-9_\u00A1-\uFFFF\.,\-_ !\(\)]/g,""),(c=y(c.extension))||(c=""),b+= c);c=y(a.title);c=null===c?null:-1!==c.indexOf("*")?c.replace("*",e("head > title").text()||"Exported data"):c;return{filename:b,title:c,messageTop:B(this,a.message||a.messageTop,"top"),messageBottom:B(this,a.messageBottom,"bottom")}});var y=function(a){return null===a||a===m?null:"function"===typeof a?a():a},B=function(a,b,c){b=y(b);if(null===b)return null;a=e("caption",a.table().container()).eq(0);return"*"===b?a.css("caption-side")!==c?null:a.length?a.text():"":b},A=e("<textarea/>")[0];e.fn.dataTable.Buttons= p;e.fn.DataTable.Buttons=p;e(r).on("init.dt plugin-init.dt",function(a,b){if("dt"===a.namespace){var c=b.oInit.buttons||i.defaults.buttons;c&&!b._buttons&&(new p(b,c)).container()}});i.ext.feature.push({fnInit:z,cFeature:"B"});i.ext.features&&i.ext.features.register("buttons",z);return p}); PK ׁ�Z`9<a a js/buttons.html5.min.jsnu �[��� (function(h){"function"===typeof define&&define.amd?define(["jquery","datatables.net","datatables.net-buttons"],function(f){return h(f,window,document)}):"object"===typeof exports?module.exports=function(f,j,v,q){f||(f=window);if(!j||!j.fn.dataTable)j=require("datatables.net")(f,j).$;j.fn.dataTable.Buttons||require("datatables.net-buttons")(f,j);return h(j,f,f.document,v,q)}:h(jQuery,window,document)})(function(h,f,j,v,q,r){function w(a){for(var c="";0<=a;)c=String.fromCharCode(a%26+65)+c,a=Math.floor(a/ 26)-1;return c}function A(a,c){x===r&&(x=-1===z.serializeToString((new f.DOMParser).parseFromString(B["xl/worksheets/sheet1.xml"],"text/xml")).indexOf("xmlns:r"));h.each(c,function(c,b){if(h.isPlainObject(b)){var e=a.folder(c);A(e,b)}else{if(x){var e=b.childNodes[0],g,k,i=[];for(g=e.attributes.length-1;0<=g;g--){k=e.attributes[g].nodeName;var f=e.attributes[g].nodeValue;-1!==k.indexOf(":")&&(i.push({name:k,value:f}),e.removeAttribute(k))}g=0;for(k=i.length;g<k;g++)f=b.createAttribute(i[g].name.replace(":", "_dt_b_namespace_token_")),f.value=i[g].value,e.setAttributeNode(f)}e=z.serializeToString(b);x&&(-1===e.indexOf("<?xml")&&(e='<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+e),e=e.replace(/_dt_b_namespace_token_/g,":"),e=e.replace(/xmlns:NS[\d]+="" NS[\d]+:/g,""));e=e.replace(/<([^<>]*?) xmlns=""([^<>]*?)>/g,"<$1 $2>");a.file(c,e)}})}function o(a,c,d){var b=a.createElement(c);d&&(d.attr&&h(b).attr(d.attr),d.children&&h.each(d.children,function(a,c){b.appendChild(c)}),null!==d.text&&d.text!== r&&b.appendChild(a.createTextNode(d.text)));return b}function L(a,c){var d=a.header[c].length,b;a.footer&&a.footer[c].length>d&&(d=a.footer[c].length);for(var e=0,g=a.body.length;e<g;e++)if(b=a.body[e][c],b=null!==b&&b!==r?b.toString():"",-1!==b.indexOf("\n")?(b=b.split("\n"),b.sort(function(a,b){return b.length-a.length}),b=b[0].length):b=b.length,b>d&&(d=b),40<d)return 54;d*=1.35;return 6<d?d:6}var p=h.fn.dataTable;p.Buttons.pdfMake=function(a){if(!a)return q||f.pdfMake;q=a};p.Buttons.jszip=function(a){if(!a)return v|| f.JSZip;v=a};var u;var l="undefined"!==typeof self&&self||"undefined"!==typeof f&&f||this.content;if("undefined"===typeof l||"undefined"!==typeof navigator&&/MSIE [1-9]\./.test(navigator.userAgent))u=void 0;else{var y=l.document.createElementNS("http://www.w3.org/1999/xhtml","a"),M="download"in y,N=/constructor/i.test(l.HTMLElement)||l.safari,C=/CriOS\/[\d]+/.test(navigator.userAgent),O=function(a){(l.setImmediate||l.setTimeout)(function(){throw a;},0)},D=function(a){setTimeout(function(){"string"=== typeof a?(l.URL||l.webkitURL||l).revokeObjectURL(a):a.remove()},4E4)},E=function(a){return/^\s*(?:text\/\S*|application\/xml|\S*\/\S*\+xml)\s*;.*charset\s*=\s*utf-8/i.test(a.type)?new Blob([String.fromCharCode(65279),a],{type:a.type}):a},F=function(a,c,d){d||(a=E(a));var b=this,d="application/octet-stream"===a.type,e,g=function(){for(var a=["writestart","progress","write","writeend"],a=[].concat(a),c=a.length;c--;){var d=b["on"+a[c]];if("function"===typeof d)try{d.call(b,b)}catch(e){O(e)}}};b.readyState= b.INIT;if(M)e=(l.URL||l.webkitURL||l).createObjectURL(a),setTimeout(function(){y.href=e;y.download=c;var a=new MouseEvent("click");y.dispatchEvent(a);g();D(e);b.readyState=b.DONE});else if((C||d&&N)&&l.FileReader){var k=new FileReader;k.onloadend=function(){var a=C?k.result:k.result.replace(/^data:[^;]*;/,"data:attachment/file;");l.open(a,"_blank")||(l.location.href=a);b.readyState=b.DONE;g()};k.readAsDataURL(a);b.readyState=b.INIT}else e||(e=(l.URL||l.webkitURL||l).createObjectURL(a)),d?l.location.href= e:l.open(e,"_blank")||(l.location.href=e),b.readyState=b.DONE,g(),D(e)},n=F.prototype;"undefined"!==typeof navigator&&navigator.msSaveOrOpenBlob?u=function(a,c,d){c=c||a.name||"download";d||(a=E(a));return navigator.msSaveOrOpenBlob(a,c)}:(n.abort=function(){},n.readyState=n.INIT=0,n.WRITING=1,n.DONE=2,n.error=n.onwritestart=n.onprogress=n.onwrite=n.onabort=n.onerror=n.onwriteend=null,u=function(a,c,d){return new F(a,c||a.name||"download",d)})}p.fileSave=u;var G=function(a){var c="Sheet1";a.sheetName&& (c=a.sheetName.replace(/[\[\]\*\/\\\?\:]/g,""));return c},H=function(a){return a.newline?a.newline:navigator.userAgent.match(/Windows/)?"\r\n":"\n"},I=function(a,c){for(var d=H(c),b=a.buttons.exportData(c.exportOptions),e=c.fieldBoundary,g=c.fieldSeparator,k=RegExp(e,"g"),i=c.escapeChar!==r?c.escapeChar:"\\",h=function(a){for(var b="",c=0,d=a.length;c<d;c++)0<c&&(b+=g),b+=e?e+(""+a[c]).replace(k,i+e)+e:a[c];return b},f=c.header?h(b.header)+d:"",l=c.footer&&b.footer?d+h(b.footer):"",j=[],m=0,o=b.body.length;m< o;m++)j.push(h(b.body[m]));return{str:f+j.join(d)+l,rows:j.length}},J=function(){if(!(-1!==navigator.userAgent.indexOf("Safari")&&-1===navigator.userAgent.indexOf("Chrome")&&-1===navigator.userAgent.indexOf("Opera")))return!1;var a=navigator.userAgent.match(/AppleWebKit\/(\d+\.\d+)/);return a&&1<a.length&&603.1>1*a[1]?!0:!1};try{var z=new XMLSerializer,x}catch(P){}var B={"_rels/.rels":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/></Relationships>', "xl/_rels/workbook.xml.rels":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/></Relationships>',"[Content_Types].xml":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types"><Default Extension="xml" ContentType="application/xml" /><Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml" /><Default Extension="jpeg" ContentType="image/jpeg" /><Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" /><Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" /><Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml" /></Types>', "xl/workbook.xml":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><fileVersion appName="xl" lastEdited="5" lowestEdited="5" rupBuild="24816"/><workbookPr showInkAnnotation="0" autoCompressPictures="0"/><bookViews><workbookView xWindow="0" yWindow="0" windowWidth="25600" windowHeight="19020" tabRatio="500"/></bookViews><sheets><sheet name="Sheet1" sheetId="1" r:id="rId1"/></sheets><definedNames/></workbook>', "xl/worksheets/sheet1.xml":'<?xml version="1.0" encoding="UTF-8" standalone="yes"?><worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><sheetData/><mergeCells count="0"/></worksheet>',"xl/styles.xml":'<?xml version="1.0" encoding="UTF-8"?><styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><numFmts count="6"><numFmt numFmtId="164" formatCode="#,##0.00_- [$$-45C]"/><numFmt numFmtId="165" formatCode=""£"#,##0.00"/><numFmt numFmtId="166" formatCode="[$€-2] #,##0.00"/><numFmt numFmtId="167" formatCode="0.0%"/><numFmt numFmtId="168" formatCode="#,##0;(#,##0)"/><numFmt numFmtId="169" formatCode="#,##0.00;(#,##0.00)"/></numFmts><fonts count="5" x14ac:knownFonts="1"><font><sz val="11" /><name val="Calibri" /></font><font><sz val="11" /><name val="Calibri" /><color rgb="FFFFFFFF" /></font><font><sz val="11" /><name val="Calibri" /><b /></font><font><sz val="11" /><name val="Calibri" /><i /></font><font><sz val="11" /><name val="Calibri" /><u /></font></fonts><fills count="6"><fill><patternFill patternType="none" /></fill><fill><patternFill patternType="none" /></fill><fill><patternFill patternType="solid"><fgColor rgb="FFD9D9D9" /><bgColor indexed="64" /></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="FFD99795" /><bgColor indexed="64" /></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="ffc6efce" /><bgColor indexed="64" /></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="ffc6cfef" /><bgColor indexed="64" /></patternFill></fill></fills><borders count="2"><border><left /><right /><top /><bottom /><diagonal /></border><border diagonalUp="false" diagonalDown="false"><left style="thin"><color auto="1" /></left><right style="thin"><color auto="1" /></right><top style="thin"><color auto="1" /></top><bottom style="thin"><color auto="1" /></bottom><diagonal /></border></borders><cellStyleXfs count="1"><xf numFmtId="0" fontId="0" fillId="0" borderId="0" /></cellStyleXfs><cellXfs count="68"><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="1" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="2" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="3" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="4" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment horizontal="left"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment horizontal="center"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment horizontal="right"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment horizontal="fill"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment textRotation="90"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1"><alignment wrapText="1"/></xf><xf numFmtId="9" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="164" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="165" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="166" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="167" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="168" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="169" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="3" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="4" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="1" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="2" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/><xf numFmtId="14" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/></cellXfs><cellStyles count="1"><cellStyle name="Normal" xfId="0" builtinId="0" /></cellStyles><dxfs count="0" /><tableStyles count="0" defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotStyleMedium4" /></styleSheet>'}, K=[{match:/^\-?\d+\.\d%$/,style:60,fmt:function(a){return a/100}},{match:/^\-?\d+\.?\d*%$/,style:56,fmt:function(a){return a/100}},{match:/^\-?\$[\d,]+.?\d*$/,style:57},{match:/^\-?£[\d,]+.?\d*$/,style:58},{match:/^\-?€[\d,]+.?\d*$/,style:59},{match:/^\-?\d+$/,style:65},{match:/^\-?\d+\.\d{2}$/,style:66},{match:/^\([\d,]+\)$/,style:61,fmt:function(a){return-1*a.replace(/[\(\)]/g,"")}},{match:/^\([\d,]+\.\d{2}\)$/,style:62,fmt:function(a){return-1*a.replace(/[\(\)]/g,"")}},{match:/^\-?[\d,]+$/,style:63}, {match:/^\-?[\d,]+\.\d{2}$/,style:64},{match:/^[\d]{4}\-[\d]{2}\-[\d]{2}$/,style:67,fmt:function(a){return Math.round(25569+Date.parse(a)/864E5)}}];p.ext.buttons.copyHtml5={className:"buttons-copy buttons-html5",text:function(a){return a.i18n("buttons.copy","Copy")},action:function(a,c,d,b){this.processing(!0);var e=this,a=I(c,b),g=c.buttons.exportInfo(b),k=H(b),i=a.str,d=h("<div/>").css({height:1,width:1,overflow:"hidden",position:"fixed",top:0,left:0});g.title&&(i=g.title+k+k+i);g.messageTop&&(i= g.messageTop+k+k+i);g.messageBottom&&(i=i+k+k+g.messageBottom);b.customize&&(i=b.customize(i,b,c));b=h("<textarea readonly/>").val(i).appendTo(d);if(j.queryCommandSupported("copy")){d.appendTo(c.table().container());b[0].focus();b[0].select();try{var f=j.execCommand("copy");d.remove();if(f){c.buttons.info(c.i18n("buttons.copyTitle","Copy to clipboard"),c.i18n("buttons.copySuccess",{1:"Copied one row to clipboard",_:"Copied %d rows to clipboard"},a.rows),2E3);this.processing(!1);return}}catch(l){}}f= h("<span>"+c.i18n("buttons.copyKeys","Press <i>ctrl</i> or <i>⌘</i> + <i>C</i> to copy the table data<br>to your system clipboard.<br><br>To cancel, click this message or press escape.")+"</span>").append(d);c.buttons.info(c.i18n("buttons.copyTitle","Copy to clipboard"),f,0);b[0].focus();b[0].select();var o=h(f).closest(".dt-button-info"),n=function(){o.off("click.buttons-copy");h(j).off(".buttons-copy");c.buttons.info(!1)};o.on("click.buttons-copy",n);h(j).on("keydown.buttons-copy",function(a){27=== a.keyCode&&(n(),e.processing(!1))}).on("copy.buttons-copy cut.buttons-copy",function(){n();e.processing(!1)})},exportOptions:{},fieldSeparator:"\t",fieldBoundary:"",header:!0,footer:!1,title:"*",messageTop:"*",messageBottom:"*"};p.ext.buttons.csvHtml5={bom:!1,className:"buttons-csv buttons-html5",available:function(){return f.FileReader!==r&&f.Blob},text:function(a){return a.i18n("buttons.csv","CSV")},action:function(a,c,d,b){this.processing(!0);var a=I(c,b).str,d=c.buttons.exportInfo(b),e=b.charset; b.customize&&(a=b.customize(a,b,c));!1!==e?(e||(e=j.characterSet||j.charset),e&&(e=";charset="+e)):e="";b.bom&&(a=""+a);u(new Blob([a],{type:"text/csv"+e}),d.filename,!0);this.processing(!1)},filename:"*",extension:".csv",exportOptions:{},fieldSeparator:",",fieldBoundary:'"',escapeChar:'"',charset:null,header:!0,footer:!1};p.ext.buttons.excelHtml5={className:"buttons-excel buttons-html5",available:function(){return f.FileReader!==r&&(v||f.JSZip)!==r&&!J()&&z},text:function(a){return a.i18n("buttons.excel", "Excel")},action:function(a,c,d,b){this.processing(!0);var e=this,g=0,k,a=function(a){return h.parseXML(B[a])},i=a("xl/worksheets/sheet1.xml"),l=i.getElementsByTagName("sheetData")[0],a={_rels:{".rels":a("_rels/.rels")},xl:{_rels:{"workbook.xml.rels":a("xl/_rels/workbook.xml.rels")},"workbook.xml":a("xl/workbook.xml"),"styles.xml":a("xl/styles.xml"),worksheets:{"sheet1.xml":i}},"[Content_Types].xml":a("[Content_Types].xml")},j=c.buttons.exportData(b.exportOptions),n,p,m=function(a){n=g+1;p=o(i,"row", {attr:{r:n}});for(var c=0,d=a.length;c<d;c++){var e=w(c)+""+n,f=null;if(null===a[c]||a[c]===r||""===a[c])if(!0===b.createEmptyCells)a[c]="";else continue;var h=a[c];a[c]="function"===typeof a[c].trim?a[c].trim():a[c];for(var j=0,k=K.length;j<k;j++){var m=K[j];if(a[c].match&&!a[c].match(/^0\d+/)&&a[c].match(m.match)){f=a[c].replace(/[^\d\.\-]/g,"");m.fmt&&(f=m.fmt(f));f=o(i,"c",{attr:{r:e,s:m.style},children:[o(i,"v",{text:f})]});break}}f||("number"===typeof a[c]||a[c].match&&a[c].match(/^-?\d+(\.\d+)?$/)&& !a[c].match(/^0\d+/)?f=o(i,"c",{attr:{t:"n",r:e},children:[o(i,"v",{text:a[c]})]}):(h=!h.replace?h:h.replace(/[\x00-\x09\x0B\x0C\x0E-\x1F\x7F-\x9F]/g,""),f=o(i,"c",{attr:{t:"inlineStr",r:e},children:{row:o(i,"is",{children:{row:o(i,"t",{text:h,attr:{"xml:space":"preserve"}})}})}})));p.appendChild(f)}l.appendChild(p);g++};b.customizeData&&b.customizeData(j);var s=function(a,c){var b=h("mergeCells",i);b[0].appendChild(o(i,"mergeCell",{attr:{ref:"A"+a+":"+w(c)+a}}));b.attr("count",parseFloat(b.attr("count"))+ 1);h("row:eq("+(a-1)+") c",i).attr("s","51")},t=c.buttons.exportInfo(b);t.title&&(m([t.title],g),s(g,j.header.length-1));t.messageTop&&(m([t.messageTop],g),s(g,j.header.length-1));b.header&&(m(j.header,g),h("row:last c",i).attr("s","2"));d=g;k=0;for(var q=j.body.length;k<q;k++)m(j.body[k],g);k=g;b.footer&&j.footer&&(m(j.footer,g),h("row:last c",i).attr("s","2"));t.messageBottom&&(m([t.messageBottom],g),s(g,j.header.length-1));m=o(i,"cols");h("worksheet",i).prepend(m);s=0;for(q=j.header.length;s<q;s++)m.appendChild(o(i, "col",{attr:{min:s+1,max:s+1,width:L(j,s),customWidth:1}}));m=a.xl["workbook.xml"];h("sheets sheet",m).attr("name",G(b));b.autoFilter&&(h("mergeCells",i).before(o(i,"autoFilter",{attr:{ref:"A"+d+":"+w(j.header.length-1)+k}})),h("definedNames",m).append(o(m,"definedName",{attr:{name:"_xlnm._FilterDatabase",localSheetId:"0",hidden:1},text:G(b)+"!$A$"+d+":"+w(j.header.length-1)+k})));b.customize&&b.customize(a,b,c);0===h("mergeCells",i).children().length&&h("mergeCells",i).remove();c=new (v||f.JSZip); d={type:"blob",mimeType:"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"};A(c,a);c.generateAsync?c.generateAsync(d).then(function(a){u(a,t.filename);e.processing(false)}):(u(c.generate(d),t.filename),this.processing(!1))},filename:"*",extension:".xlsx",exportOptions:{},header:!0,footer:!1,title:"*",messageTop:"*",messageBottom:"*",createEmptyCells:!1,autoFilter:!1,sheetName:""};p.ext.buttons.pdfHtml5={className:"buttons-pdf buttons-html5",available:function(){return f.FileReader!== r&&(q||f.pdfMake)},text:function(a){return a.i18n("buttons.pdf","PDF")},action:function(a,c,d,b){this.processing(!0);var d=c.buttons.exportData(b.exportOptions),a=c.buttons.exportInfo(b),e=[];b.header&&e.push(h.map(d.header,function(a){return{text:"string"===typeof a?a:a+"",style:"tableHeader"}}));for(var g=0,j=d.body.length;g<j;g++)e.push(h.map(d.body[g],function(a){if(null===a||a===r)a="";return{text:"string"===typeof a?a:a+"",style:g%2?"tableBodyEven":"tableBodyOdd"}}));b.footer&&d.footer&&e.push(h.map(d.footer, function(a){return{text:"string"===typeof a?a:a+"",style:"tableFooter"}}));d={pageSize:b.pageSize,pageOrientation:b.orientation,content:[{table:{headerRows:1,body:e},layout:"noBorders"}],styles:{tableHeader:{bold:!0,fontSize:11,color:"white",fillColor:"#2d4154",alignment:"center"},tableBodyEven:{},tableBodyOdd:{fillColor:"#f3f3f3"},tableFooter:{bold:!0,fontSize:11,color:"white",fillColor:"#2d4154"},title:{alignment:"center",fontSize:15},message:{}},defaultStyle:{fontSize:10}};a.messageTop&&d.content.unshift({text:a.messageTop, style:"message",margin:[0,0,0,12]});a.messageBottom&&d.content.push({text:a.messageBottom,style:"message",margin:[0,0,0,12]});a.title&&d.content.unshift({text:a.title,style:"title",margin:[0,0,0,12]});b.customize&&b.customize(d,b,c);c=(q||f.pdfMake).createPdf(d);"open"===b.download&&!J()?c.open():c.download(a.filename);this.processing(!1)},title:"*",filename:"*",extension:".pdf",exportOptions:{},orientation:"portrait",pageSize:"A4",header:!0,footer:!1,messageTop:"*",messageBottom:"*",customize:null, download:"download"};return p.Buttons}); PK ׁ�Zf)��� �� js/buttons.flash.jsnu �[��� /*! * Flash export buttons for Buttons and DataTables. * 2015-2017 SpryMedia Ltd - datatables.net/license * * ZeroClipbaord - MIT license * Copyright (c) 2012 Joseph Huckaby */ (function( factory ){ if ( typeof define === 'function' && define.amd ) { // AMD define( ['jquery', 'datatables.net', 'datatables.net-buttons'], function ( $ ) { return factory( $, window, document ); } ); } else if ( typeof exports === 'object' ) { // CommonJS module.exports = function (root, $) { if ( ! root ) { root = window; } if ( ! $ || ! $.fn.dataTable ) { $ = require('datatables.net')(root, $).$; } if ( ! $.fn.dataTable.Buttons ) { require('datatables.net-buttons')(root, $); } return factory( $, root, root.document ); }; } else { // Browser factory( jQuery, window, document ); } }(function( $, window, document, undefined ) { 'use strict'; var DataTable = $.fn.dataTable; /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ZeroClipboard dependency */ /* * ZeroClipboard 1.0.4 with modifications * Author: Joseph Huckaby * License: MIT * * Copyright (c) 2012 Joseph Huckaby */ var ZeroClipboard_TableTools = { version: "1.0.4-TableTools2", clients: {}, // registered upload clients on page, indexed by id moviePath: '', // URL to movie nextId: 1, // ID of next movie $: function(thingy) { // simple DOM lookup utility function if (typeof(thingy) == 'string') { thingy = document.getElementById(thingy); } if (!thingy.addClass) { // extend element with a few useful methods thingy.hide = function() { this.style.display = 'none'; }; thingy.show = function() { this.style.display = ''; }; thingy.addClass = function(name) { this.removeClass(name); this.className += ' ' + name; }; thingy.removeClass = function(name) { this.className = this.className.replace( new RegExp("\\s*" + name + "\\s*"), " ").replace(/^\s+/, '').replace(/\s+$/, ''); }; thingy.hasClass = function(name) { return !!this.className.match( new RegExp("\\s*" + name + "\\s*") ); }; } return thingy; }, setMoviePath: function(path) { // set path to ZeroClipboard.swf this.moviePath = path; }, dispatch: function(id, eventName, args) { // receive event from flash movie, send to client var client = this.clients[id]; if (client) { client.receiveEvent(eventName, args); } }, log: function ( str ) { console.log( 'Flash: '+str ); }, register: function(id, client) { // register new client to receive events this.clients[id] = client; }, getDOMObjectPosition: function(obj) { // get absolute coordinates for dom element var info = { left: 0, top: 0, width: obj.width ? obj.width : obj.offsetWidth, height: obj.height ? obj.height : obj.offsetHeight }; if ( obj.style.width !== "" ) { info.width = obj.style.width.replace("px",""); } if ( obj.style.height !== "" ) { info.height = obj.style.height.replace("px",""); } while (obj) { info.left += obj.offsetLeft; info.top += obj.offsetTop; obj = obj.offsetParent; } return info; }, Client: function(elem) { // constructor for new simple upload client this.handlers = {}; // unique ID this.id = ZeroClipboard_TableTools.nextId++; this.movieId = 'ZeroClipboard_TableToolsMovie_' + this.id; // register client with singleton to receive flash events ZeroClipboard_TableTools.register(this.id, this); // create movie if (elem) { this.glue(elem); } } }; ZeroClipboard_TableTools.Client.prototype = { id: 0, // unique ID for us ready: false, // whether movie is ready to receive events or not movie: null, // reference to movie object clipText: '', // text to copy to clipboard fileName: '', // default file save name action: 'copy', // action to perform handCursorEnabled: true, // whether to show hand cursor, or default pointer cursor cssEffects: true, // enable CSS mouse effects on dom container handlers: null, // user event handlers sized: false, sheetName: '', // default sheet name for excel export glue: function(elem, title) { // glue to DOM element // elem can be ID or actual DOM element object this.domElement = ZeroClipboard_TableTools.$(elem); // float just above object, or zIndex 99 if dom element isn't set var zIndex = 99; if (this.domElement.style.zIndex) { zIndex = parseInt(this.domElement.style.zIndex, 10) + 1; } // find X/Y position of domElement var box = ZeroClipboard_TableTools.getDOMObjectPosition(this.domElement); // create floating DIV above element this.div = document.createElement('div'); var style = this.div.style; style.position = 'absolute'; style.left = '0px'; style.top = '0px'; style.width = (box.width) + 'px'; style.height = box.height + 'px'; style.zIndex = zIndex; if ( typeof title != "undefined" && title !== "" ) { this.div.title = title; } if ( box.width !== 0 && box.height !== 0 ) { this.sized = true; } // style.backgroundColor = '#f00'; // debug if ( this.domElement ) { this.domElement.appendChild(this.div); this.div.innerHTML = this.getHTML( box.width, box.height ).replace(/&/g, '&'); } }, positionElement: function() { var box = ZeroClipboard_TableTools.getDOMObjectPosition(this.domElement); var style = this.div.style; style.position = 'absolute'; //style.left = (this.domElement.offsetLeft)+'px'; //style.top = this.domElement.offsetTop+'px'; style.width = box.width + 'px'; style.height = box.height + 'px'; if ( box.width !== 0 && box.height !== 0 ) { this.sized = true; } else { return; } var flash = this.div.childNodes[0]; flash.width = box.width; flash.height = box.height; }, getHTML: function(width, height) { // return HTML for movie var html = ''; var flashvars = 'id=' + this.id + '&width=' + width + '&height=' + height; if (navigator.userAgent.match(/MSIE/)) { // IE gets an OBJECT tag var protocol = location.href.match(/^https/i) ? 'https://' : 'http://'; html += '<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="'+protocol+'download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=10,0,0,0" width="'+width+'" height="'+height+'" id="'+this.movieId+'" align="middle"><param name="allowScriptAccess" value="always" /><param name="allowFullScreen" value="false" /><param name="movie" value="'+ZeroClipboard_TableTools.moviePath+'" /><param name="loop" value="false" /><param name="menu" value="false" /><param name="quality" value="best" /><param name="bgcolor" value="#ffffff" /><param name="flashvars" value="'+flashvars+'"/><param name="wmode" value="transparent"/></object>'; } else { // all other browsers get an EMBED tag html += '<embed id="'+this.movieId+'" src="'+ZeroClipboard_TableTools.moviePath+'" loop="false" menu="false" quality="best" bgcolor="#ffffff" width="'+width+'" height="'+height+'" name="'+this.movieId+'" align="middle" allowScriptAccess="always" allowFullScreen="false" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" flashvars="'+flashvars+'" wmode="transparent" />'; } return html; }, hide: function() { // temporarily hide floater offscreen if (this.div) { this.div.style.left = '-2000px'; } }, show: function() { // show ourselves after a call to hide() this.reposition(); }, destroy: function() { // destroy control and floater var that = this; if (this.domElement && this.div) { $(this.div).remove(); this.domElement = null; this.div = null; $.each( ZeroClipboard_TableTools.clients, function ( id, client ) { if ( client === that ) { delete ZeroClipboard_TableTools.clients[ id ]; } } ); } }, reposition: function(elem) { // reposition our floating div, optionally to new container // warning: container CANNOT change size, only position if (elem) { this.domElement = ZeroClipboard_TableTools.$(elem); if (!this.domElement) { this.hide(); } } if (this.domElement && this.div) { var box = ZeroClipboard_TableTools.getDOMObjectPosition(this.domElement); var style = this.div.style; style.left = '' + box.left + 'px'; style.top = '' + box.top + 'px'; } }, clearText: function() { // clear the text to be copy / saved this.clipText = ''; if (this.ready) { this.movie.clearText(); } }, appendText: function(newText) { // append text to that which is to be copied / saved this.clipText += newText; if (this.ready) { this.movie.appendText(newText) ;} }, setText: function(newText) { // set text to be copied to be copied / saved this.clipText = newText; if (this.ready) { this.movie.setText(newText) ;} }, setFileName: function(newText) { // set the file name this.fileName = newText; if (this.ready) { this.movie.setFileName(newText); } }, setSheetData: function(data) { // set the xlsx sheet data if (this.ready) { this.movie.setSheetData( JSON.stringify( data ) ); } }, setAction: function(newText) { // set action (save or copy) this.action = newText; if (this.ready) { this.movie.setAction(newText); } }, addEventListener: function(eventName, func) { // add user event listener for event // event types: load, queueStart, fileStart, fileComplete, queueComplete, progress, error, cancel eventName = eventName.toString().toLowerCase().replace(/^on/, ''); if (!this.handlers[eventName]) { this.handlers[eventName] = []; } this.handlers[eventName].push(func); }, setHandCursor: function(enabled) { // enable hand cursor (true), or default arrow cursor (false) this.handCursorEnabled = enabled; if (this.ready) { this.movie.setHandCursor(enabled); } }, setCSSEffects: function(enabled) { // enable or disable CSS effects on DOM container this.cssEffects = !!enabled; }, receiveEvent: function(eventName, args) { var self; // receive event from flash eventName = eventName.toString().toLowerCase().replace(/^on/, ''); // special behavior for certain events switch (eventName) { case 'load': // movie claims it is ready, but in IE this isn't always the case... // bug fix: Cannot extend EMBED DOM elements in Firefox, must use traditional function this.movie = document.getElementById(this.movieId); if (!this.movie) { self = this; setTimeout( function() { self.receiveEvent('load', null); }, 1 ); return; } // firefox on pc needs a "kick" in order to set these in certain cases if (!this.ready && navigator.userAgent.match(/Firefox/) && navigator.userAgent.match(/Windows/)) { self = this; setTimeout( function() { self.receiveEvent('load', null); }, 100 ); this.ready = true; return; } this.ready = true; this.movie.clearText(); this.movie.appendText( this.clipText ); this.movie.setFileName( this.fileName ); this.movie.setAction( this.action ); this.movie.setHandCursor( this.handCursorEnabled ); break; case 'mouseover': if (this.domElement && this.cssEffects) { //this.domElement.addClass('hover'); if (this.recoverActive) { this.domElement.addClass('active'); } } break; case 'mouseout': if (this.domElement && this.cssEffects) { this.recoverActive = false; if (this.domElement.hasClass('active')) { this.domElement.removeClass('active'); this.recoverActive = true; } //this.domElement.removeClass('hover'); } break; case 'mousedown': if (this.domElement && this.cssEffects) { this.domElement.addClass('active'); } break; case 'mouseup': if (this.domElement && this.cssEffects) { this.domElement.removeClass('active'); this.recoverActive = false; } break; } // switch eventName if (this.handlers[eventName]) { for (var idx = 0, len = this.handlers[eventName].length; idx < len; idx++) { var func = this.handlers[eventName][idx]; if (typeof(func) == 'function') { // actual function reference func(this, args); } else if ((typeof(func) == 'object') && (func.length == 2)) { // PHP style object + method, i.e. [myObject, 'myMethod'] func[0][ func[1] ](this, args); } else if (typeof(func) == 'string') { // name of function window[func](this, args); } } // foreach event handler defined } // user defined handler for event } }; ZeroClipboard_TableTools.hasFlash = function () { try { var fo = new ActiveXObject('ShockwaveFlash.ShockwaveFlash'); if (fo) { return true; } } catch (e) { if ( navigator.mimeTypes && navigator.mimeTypes['application/x-shockwave-flash'] !== undefined && navigator.mimeTypes['application/x-shockwave-flash'].enabledPlugin ) { return true; } } return false; }; // For the Flash binding to work, ZeroClipboard_TableTools must be on the global // object list window.ZeroClipboard_TableTools = ZeroClipboard_TableTools; /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Local (private) functions */ /** * If a Buttons instance is initlaised before it is placed into the DOM, Flash * won't be able to bind to it, so we need to wait until it is available, this * method abstracts that out. * * @param {ZeroClipboard} flash ZeroClipboard instance * @param {jQuery} node Button */ var _glue = function ( flash, node ) { var id = node.attr('id'); if ( node.parents('html').length ) { flash.glue( node[0], '' ); } else { setTimeout( function () { _glue( flash, node ); }, 500 ); } }; /** * Get the sheet name for Excel exports. * * @param {object} config Button configuration */ var _sheetname = function ( config ) { var sheetName = 'Sheet1'; if ( config.sheetName ) { sheetName = config.sheetName.replace(/[\[\]\*\/\\\?\:]/g, ''); } return sheetName; }; /** * Set the flash text. This has to be broken up into chunks as the Javascript / * Flash bridge has a size limit. There is no indication in the Flash * documentation what this is, and it probably depends upon the browser. * Experimentation shows that the point is around 50k when data starts to get * lost, so an 8K limit used here is safe. * * @param {ZeroClipboard} flash ZeroClipboard instance * @param {string} data Data to send to Flash */ var _setText = function ( flash, data ) { var parts = data.match(/[\s\S]{1,8192}/g) || []; flash.clearText(); for ( var i=0, len=parts.length ; i<len ; i++ ) { flash.appendText( parts[i] ); } }; /** * Get the newline character(s) * * @param {object} config Button configuration * @return {string} Newline character */ var _newLine = function ( config ) { return config.newline ? config.newline : navigator.userAgent.match(/Windows/) ? '\r\n' : '\n'; }; /** * Combine the data from the `buttons.exportData` method into a string that * will be used in the export file. * * @param {DataTable.Api} dt DataTables API instance * @param {object} config Button configuration * @return {object} The data to export */ var _exportData = function ( dt, config ) { var newLine = _newLine( config ); var data = dt.buttons.exportData( config.exportOptions ); var boundary = config.fieldBoundary; var separator = config.fieldSeparator; var reBoundary = new RegExp( boundary, 'g' ); var escapeChar = config.escapeChar !== undefined ? config.escapeChar : '\\'; var join = function ( a ) { var s = ''; // If there is a field boundary, then we might need to escape it in // the source data for ( var i=0, ien=a.length ; i<ien ; i++ ) { if ( i > 0 ) { s += separator; } s += boundary ? boundary + ('' + a[i]).replace( reBoundary, escapeChar+boundary ) + boundary : a[i]; } return s; }; var header = config.header ? join( data.header )+newLine : ''; var footer = config.footer && data.footer ? newLine+join( data.footer ) : ''; var body = []; for ( var i=0, ien=data.body.length ; i<ien ; i++ ) { body.push( join( data.body[i] ) ); } return { str: header + body.join( newLine ) + footer, rows: body.length }; }; // Basic initialisation for the buttons is common between them var flashButton = { available: function () { return ZeroClipboard_TableTools.hasFlash(); }, init: function ( dt, button, config ) { // Insert the Flash movie ZeroClipboard_TableTools.moviePath = DataTable.Buttons.swfPath; var flash = new ZeroClipboard_TableTools.Client(); flash.setHandCursor( true ); flash.addEventListener('mouseDown', function(client) { config._fromFlash = true; dt.button( button[0] ).trigger(); config._fromFlash = false; } ); _glue( flash, button ); config._flash = flash; }, destroy: function ( dt, button, config ) { config._flash.destroy(); }, fieldSeparator: ',', fieldBoundary: '"', exportOptions: {}, title: '*', messageTop: '*', messageBottom: '*', filename: '*', extension: '.csv', header: true, footer: false }; /** * Convert from numeric position to letter for column names in Excel * @param {int} n Column number * @return {string} Column letter(s) name */ function createCellPos( n ){ var ordA = 'A'.charCodeAt(0); var ordZ = 'Z'.charCodeAt(0); var len = ordZ - ordA + 1; var s = ""; while( n >= 0 ) { s = String.fromCharCode(n % len + ordA) + s; n = Math.floor(n / len) - 1; } return s; } /** * Create an XML node and add any children, attributes, etc without needing to * be verbose in the DOM. * * @param {object} doc XML document * @param {string} nodeName Node name * @param {object} opts Options - can be `attr` (attributes), `children` * (child nodes) and `text` (text content) * @return {node} Created node */ function _createNode( doc, nodeName, opts ){ var tempNode = doc.createElement( nodeName ); if ( opts ) { if ( opts.attr ) { $(tempNode).attr( opts.attr ); } if ( opts.children ) { $.each( opts.children, function ( key, value ) { tempNode.appendChild( value ); } ); } if ( opts.text !== null && opts.text !== undefined ) { tempNode.appendChild( doc.createTextNode( opts.text ) ); } } return tempNode; } /** * Get the width for an Excel column based on the contents of that column * @param {object} data Data for export * @param {int} col Column index * @return {int} Column width */ function _excelColWidth( data, col ) { var max = data.header[col].length; var len, lineSplit, str; if ( data.footer && data.footer[col].length > max ) { max = data.footer[col].length; } for ( var i=0, ien=data.body.length ; i<ien ; i++ ) { var point = data.body[i][col]; str = point !== null && point !== undefined ? point.toString() : ''; // If there is a newline character, workout the width of the column // based on the longest line in the string if ( str.indexOf('\n') !== -1 ) { lineSplit = str.split('\n'); lineSplit.sort( function (a, b) { return b.length - a.length; } ); len = lineSplit[0].length; } else { len = str.length; } if ( len > max ) { max = len; } // Max width rather than having potentially massive column widths if ( max > 40 ) { return 52; // 40 * 1.3 } } max *= 1.3; // And a min width return max > 6 ? max : 6; } var _serialiser = ""; if (typeof window.XMLSerializer === 'undefined') { _serialiser = new function () { this.serializeToString = function (input) { return input.xml } }; } else { _serialiser = new XMLSerializer(); } var _ieExcel; /** * Convert XML documents in an object to strings * @param {object} obj XLSX document object */ function _xlsxToStrings( obj ) { if ( _ieExcel === undefined ) { // Detect if we are dealing with IE's _awful_ serialiser by seeing if it // drop attributes _ieExcel = _serialiser .serializeToString( $.parseXML( excelStrings['xl/worksheets/sheet1.xml'] ) ) .indexOf( 'xmlns:r' ) === -1; } $.each( obj, function ( name, val ) { if ( $.isPlainObject( val ) ) { _xlsxToStrings( val ); } else { if ( _ieExcel ) { // IE's XML serialiser will drop some name space attributes from // from the root node, so we need to save them. Do this by // replacing the namespace nodes with a regular attribute that // we convert back when serialised. Edge does not have this // issue var worksheet = val.childNodes[0]; var i, ien; var attrs = []; for ( i=worksheet.attributes.length-1 ; i>=0 ; i-- ) { var attrName = worksheet.attributes[i].nodeName; var attrValue = worksheet.attributes[i].nodeValue; if ( attrName.indexOf( ':' ) !== -1 ) { attrs.push( { name: attrName, value: attrValue } ); worksheet.removeAttribute( attrName ); } } for ( i=0, ien=attrs.length ; i<ien ; i++ ) { var attr = val.createAttribute( attrs[i].name.replace( ':', '_dt_b_namespace_token_' ) ); attr.value = attrs[i].value; worksheet.setAttributeNode( attr ); } } var str = _serialiser.serializeToString(val); // Fix IE's XML if ( _ieExcel ) { // IE doesn't include the XML declaration if ( str.indexOf( '<?xml' ) === -1 ) { str = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+str; } // Return namespace attributes to being as such str = str.replace( /_dt_b_namespace_token_/g, ':' ); } // Safari, IE and Edge will put empty name space attributes onto // various elements making them useless. This strips them out str = str.replace( /<([^<>]*?) xmlns=""([^<>]*?)>/g, '<$1 $2>' ); obj[ name ] = str; } } ); } // Excel - Pre-defined strings to build a basic XLSX file var excelStrings = { "_rels/.rels": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">'+ '<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/>'+ '</Relationships>', "xl/_rels/workbook.xml.rels": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">'+ '<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/>'+ '<Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/>'+ '</Relationships>', "[Content_Types].xml": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types">'+ '<Default Extension="xml" ContentType="application/xml" />'+ '<Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml" />'+ '<Default Extension="jpeg" ContentType="image/jpeg" />'+ '<Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" />'+ '<Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" />'+ '<Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml" />'+ '</Types>', "xl/workbook.xml": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">'+ '<fileVersion appName="xl" lastEdited="5" lowestEdited="5" rupBuild="24816"/>'+ '<workbookPr showInkAnnotation="0" autoCompressPictures="0"/>'+ '<bookViews>'+ '<workbookView xWindow="0" yWindow="0" windowWidth="25600" windowHeight="19020" tabRatio="500"/>'+ '</bookViews>'+ '<sheets>'+ '<sheet name="" sheetId="1" r:id="rId1"/>'+ '</sheets>'+ '</workbook>', "xl/worksheets/sheet1.xml": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">'+ '<sheetData/>'+ '<mergeCells count="0"/>'+ '</worksheet>', "xl/styles.xml": '<?xml version="1.0" encoding="UTF-8"?>'+ '<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">'+ '<numFmts count="6">'+ '<numFmt numFmtId="164" formatCode="#,##0.00_-\ [$$-45C]"/>'+ '<numFmt numFmtId="165" formatCode=""£"#,##0.00"/>'+ '<numFmt numFmtId="166" formatCode="[$€-2]\ #,##0.00"/>'+ '<numFmt numFmtId="167" formatCode="0.0%"/>'+ '<numFmt numFmtId="168" formatCode="#,##0;(#,##0)"/>'+ '<numFmt numFmtId="169" formatCode="#,##0.00;(#,##0.00)"/>'+ '</numFmts>'+ '<fonts count="5" x14ac:knownFonts="1">'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '</font>'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '<color rgb="FFFFFFFF" />'+ '</font>'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '<b />'+ '</font>'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '<i />'+ '</font>'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '<u />'+ '</font>'+ '</fonts>'+ '<fills count="6">'+ '<fill>'+ '<patternFill patternType="none" />'+ '</fill>'+ '<fill>'+ // Excel appears to use this as a dotted background regardless of values but '<patternFill patternType="none" />'+ // to be valid to the schema, use a patternFill '</fill>'+ '<fill>'+ '<patternFill patternType="solid">'+ '<fgColor rgb="FFD9D9D9" />'+ '<bgColor indexed="64" />'+ '</patternFill>'+ '</fill>'+ '<fill>'+ '<patternFill patternType="solid">'+ '<fgColor rgb="FFD99795" />'+ '<bgColor indexed="64" />'+ '</patternFill>'+ '</fill>'+ '<fill>'+ '<patternFill patternType="solid">'+ '<fgColor rgb="ffc6efce" />'+ '<bgColor indexed="64" />'+ '</patternFill>'+ '</fill>'+ '<fill>'+ '<patternFill patternType="solid">'+ '<fgColor rgb="ffc6cfef" />'+ '<bgColor indexed="64" />'+ '</patternFill>'+ '</fill>'+ '</fills>'+ '<borders count="2">'+ '<border>'+ '<left />'+ '<right />'+ '<top />'+ '<bottom />'+ '<diagonal />'+ '</border>'+ '<border diagonalUp="false" diagonalDown="false">'+ '<left style="thin">'+ '<color auto="1" />'+ '</left>'+ '<right style="thin">'+ '<color auto="1" />'+ '</right>'+ '<top style="thin">'+ '<color auto="1" />'+ '</top>'+ '<bottom style="thin">'+ '<color auto="1" />'+ '</bottom>'+ '<diagonal />'+ '</border>'+ '</borders>'+ '<cellStyleXfs count="1">'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" />'+ '</cellStyleXfs>'+ '<cellXfs count="61">'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment horizontal="left"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment horizontal="center"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment horizontal="right"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment horizontal="fill"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment textRotation="90"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment wrapText="1"/>'+ '</xf>'+ '<xf numFmtId="9" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="164" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="165" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="166" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="167" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="168" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="169" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="3" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="4" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '</cellXfs>'+ '<cellStyles count="1">'+ '<cellStyle name="Normal" xfId="0" builtinId="0" />'+ '</cellStyles>'+ '<dxfs count="0" />'+ '<tableStyles count="0" defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotStyleMedium4" />'+ '</styleSheet>' }; // Note we could use 3 `for` loops for the styles, but when gzipped there is // virtually no difference in size, since the above can be easily compressed // Pattern matching for special number formats. Perhaps this should be exposed // via an API in future? var _excelSpecials = [ { match: /^\-?\d+\.\d%$/, style: 60, fmt: function (d) { return d/100; } }, // Precent with d.p. { match: /^\-?\d+\.?\d*%$/, style: 56, fmt: function (d) { return d/100; } }, // Percent { match: /^\-?\$[\d,]+.?\d*$/, style: 57 }, // Dollars { match: /^\-?£[\d,]+.?\d*$/, style: 58 }, // Pounds { match: /^\-?€[\d,]+.?\d*$/, style: 59 }, // Euros { match: /^\([\d,]+\)$/, style: 61, fmt: function (d) { return -1 * d.replace(/[\(\)]/g, ''); } }, // Negative numbers indicated by brackets { match: /^\([\d,]+\.\d{2}\)$/, style: 62, fmt: function (d) { return -1 * d.replace(/[\(\)]/g, ''); } }, // Negative numbers indicated by brackets - 2d.p. { match: /^[\d,]+$/, style: 63 }, // Numbers with thousand separators { match: /^[\d,]+\.\d{2}$/, style: 64 } // Numbers with 2d.p. and thousands separators ]; /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * DataTables options and methods */ // Set the default SWF path DataTable.Buttons.swfPath = '//cdn.datatables.net/buttons/'+DataTable.Buttons.version+'/swf/flashExport.swf'; // Method to allow Flash buttons to be resized when made visible - as they are // of zero height and width if initialised hidden DataTable.Api.register( 'buttons.resize()', function () { $.each( ZeroClipboard_TableTools.clients, function ( i, client ) { if ( client.domElement !== undefined && client.domElement.parentNode ) { client.positionElement(); } } ); } ); /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Button definitions */ // Copy to clipboard DataTable.ext.buttons.copyFlash = $.extend( {}, flashButton, { className: 'buttons-copy buttons-flash', text: function ( dt ) { return dt.i18n( 'buttons.copy', 'Copy' ); }, action: function ( e, dt, button, config ) { // Check that the trigger did actually occur due to a Flash activation if ( ! config._fromFlash ) { return; } this.processing( true ); var flash = config._flash; var exportData = _exportData( dt, config ); var info = dt.buttons.exportInfo( config ); var newline = _newLine(config); var output = exportData.str; if ( info.title ) { output = info.title + newline + newline + output; } if ( info.messageTop ) { output = info.messageTop + newline + newline + output; } if ( info.messageBottom ) { output = output + newline + newline + info.messageBottom; } if ( config.customize ) { output = config.customize( output, config, dt ); } flash.setAction( 'copy' ); _setText( flash, output ); this.processing( false ); dt.buttons.info( dt.i18n( 'buttons.copyTitle', 'Copy to clipboard' ), dt.i18n( 'buttons.copySuccess', { _: 'Copied %d rows to clipboard', 1: 'Copied 1 row to clipboard' }, data.rows ), 3000 ); }, fieldSeparator: '\t', fieldBoundary: '' } ); // CSV save file DataTable.ext.buttons.csvFlash = $.extend( {}, flashButton, { className: 'buttons-csv buttons-flash', text: function ( dt ) { return dt.i18n( 'buttons.csv', 'CSV' ); }, action: function ( e, dt, button, config ) { // Set the text var flash = config._flash; var data = _exportData( dt, config ); var info = dt.buttons.exportInfo( config ); var output = config.customize ? config.customize( data.str, config, dt ) : data.str; flash.setAction( 'csv' ); flash.setFileName( info.filename ); _setText( flash, output ); }, escapeChar: '"' } ); // Excel save file - this is really a CSV file using UTF-8 that Excel can read DataTable.ext.buttons.excelFlash = $.extend( {}, flashButton, { className: 'buttons-excel buttons-flash', text: function ( dt ) { return dt.i18n( 'buttons.excel', 'Excel' ); }, action: function ( e, dt, button, config ) { this.processing( true ); var flash = config._flash; var rowPos = 0; var rels = $.parseXML( excelStrings['xl/worksheets/sheet1.xml'] ) ; //Parses xml var relsGet = rels.getElementsByTagName( "sheetData" )[0]; var xlsx = { _rels: { ".rels": $.parseXML( excelStrings['_rels/.rels'] ) }, xl: { _rels: { "workbook.xml.rels": $.parseXML( excelStrings['xl/_rels/workbook.xml.rels'] ) }, "workbook.xml": $.parseXML( excelStrings['xl/workbook.xml'] ), "styles.xml": $.parseXML( excelStrings['xl/styles.xml'] ), "worksheets": { "sheet1.xml": rels } }, "[Content_Types].xml": $.parseXML( excelStrings['[Content_Types].xml']) }; var data = dt.buttons.exportData( config.exportOptions ); var currentRow, rowNode; var addRow = function ( row ) { currentRow = rowPos+1; rowNode = _createNode( rels, "row", { attr: {r:currentRow} } ); for ( var i=0, ien=row.length ; i<ien ; i++ ) { // Concat both the Cell Columns as a letter and the Row of the cell. var cellId = createCellPos(i) + '' + currentRow; var cell = null; // For null, undefined of blank cell, continue so it doesn't create the _createNode if ( row[i] === null || row[i] === undefined || row[i] === '' ) { if ( config.createEmptyCells === true ) { row[i] = ''; } else { continue; } } row[i] = typeof row[i].trim === 'function' ? row[i].trim() : row[i]; // Special number formatting options for ( var j=0, jen=_excelSpecials.length ; j<jen ; j++ ) { var special = _excelSpecials[j]; // TODO Need to provide the ability for the specials to say // if they are returning a string, since at the moment it is // assumed to be a number if ( row[i].match && ! row[i].match(/^0\d+/) && row[i].match( special.match ) ) { var val = row[i].replace(/[^\d\.\-]/g, ''); if ( special.fmt ) { val = special.fmt( val ); } cell = _createNode( rels, 'c', { attr: { r: cellId, s: special.style }, children: [ _createNode( rels, 'v', { text: val } ) ] } ); break; } } if ( ! cell ) { if ( typeof row[i] === 'number' || ( row[i].match && row[i].match(/^-?\d+(\.\d+)?$/) && ! row[i].match(/^0\d+/) ) ) { // Detect numbers - don't match numbers with leading zeros // or a negative anywhere but the start cell = _createNode( rels, 'c', { attr: { t: 'n', r: cellId }, children: [ _createNode( rels, 'v', { text: row[i] } ) ] } ); } else { // String output - replace non standard characters for text output var text = ! row[i].replace ? row[i] : row[i].replace(/[\x00-\x09\x0B\x0C\x0E-\x1F\x7F-\x9F]/g, ''); cell = _createNode( rels, 'c', { attr: { t: 'inlineStr', r: cellId }, children:{ row: _createNode( rels, 'is', { children: { row: _createNode( rels, 't', { text: text } ) } } ) } } ); } } rowNode.appendChild( cell ); } relsGet.appendChild(rowNode); rowPos++; }; $( 'sheets sheet', xlsx.xl['workbook.xml'] ).attr( 'name', _sheetname( config ) ); if ( config.customizeData ) { config.customizeData( data ); } var mergeCells = function ( row, colspan ) { var mergeCells = $('mergeCells', rels); mergeCells[0].appendChild( _createNode( rels, 'mergeCell', { attr: { ref: 'A'+row+':'+createCellPos(colspan)+row } } ) ); mergeCells.attr( 'count', mergeCells.attr( 'count' )+1 ); $('row:eq('+(row-1)+') c', rels).attr( 's', '51' ); // centre }; // Title and top messages var exportInfo = dt.buttons.exportInfo( config ); if ( exportInfo.title ) { addRow( [exportInfo.title], rowPos ); mergeCells( rowPos, data.header.length-1 ); } if ( exportInfo.messageTop ) { addRow( [exportInfo.messageTop], rowPos ); mergeCells( rowPos, data.header.length-1 ); } // Table itself if ( config.header ) { addRow( data.header, rowPos ); $('row:last c', rels).attr( 's', '2' ); // bold } for ( var n=0, ie=data.body.length ; n<ie ; n++ ) { addRow( data.body[n], rowPos ); } if ( config.footer && data.footer ) { addRow( data.footer, rowPos); $('row:last c', rels).attr( 's', '2' ); // bold } // Below the table if ( exportInfo.messageBottom ) { addRow( [exportInfo.messageBottom], rowPos ); mergeCells( rowPos, data.header.length-1 ); } // Set column widths var cols = _createNode( rels, 'cols' ); $('worksheet', rels).prepend( cols ); for ( var i=0, ien=data.header.length ; i<ien ; i++ ) { cols.appendChild( _createNode( rels, 'col', { attr: { min: i+1, max: i+1, width: _excelColWidth( data, i ), customWidth: 1 } } ) ); } // Let the developer customise the document if they want to if ( config.customize ) { config.customize( xlsx, config, dt ); } _xlsxToStrings( xlsx ); flash.setAction( 'excel' ); flash.setFileName( exportInfo.filename ); flash.setSheetData( xlsx ); _setText( flash, '' ); this.processing( false ); }, extension: '.xlsx', createEmptyCells: false } ); // PDF export DataTable.ext.buttons.pdfFlash = $.extend( {}, flashButton, { className: 'buttons-pdf buttons-flash', text: function ( dt ) { return dt.i18n( 'buttons.pdf', 'PDF' ); }, action: function ( e, dt, button, config ) { this.processing( true ); // Set the text var flash = config._flash; var data = dt.buttons.exportData( config.exportOptions ); var info = dt.buttons.exportInfo( config ); var totalWidth = dt.table().node().offsetWidth; // Calculate the column width ratios for layout of the table in the PDF var ratios = dt.columns( config.columns ).indexes().map( function ( idx ) { return dt.column( idx ).header().offsetWidth / totalWidth; } ); flash.setAction( 'pdf' ); flash.setFileName( info.filename ); _setText( flash, JSON.stringify( { title: info.title || '', messageTop: info.messageTop || '', messageBottom: info.messageBottom || '', colWidth: ratios.toArray(), orientation: config.orientation, size: config.pageSize, header: config.header ? data.header : null, footer: config.footer ? data.footer : null, body: data.body } ) ); this.processing( false ); }, extension: '.pdf', orientation: 'portrait', pageSize: 'A4', newline: '\n' } ); return DataTable.Buttons; })); PK ׁ�Z|�2u u js/buttons.colVis.jsnu �[��� /*! * Column visibility buttons for Buttons and DataTables. * 2016 SpryMedia Ltd - datatables.net/license */ (function( factory ){ if ( typeof define === 'function' && define.amd ) { // AMD define( ['jquery', 'datatables.net', 'datatables.net-buttons'], function ( $ ) { return factory( $, window, document ); } ); } else if ( typeof exports === 'object' ) { // CommonJS module.exports = function (root, $) { if ( ! root ) { root = window; } if ( ! $ || ! $.fn.dataTable ) { $ = require('datatables.net')(root, $).$; } if ( ! $.fn.dataTable.Buttons ) { require('datatables.net-buttons')(root, $); } return factory( $, root, root.document ); }; } else { // Browser factory( jQuery, window, document ); } }(function( $, window, document, undefined ) { 'use strict'; var DataTable = $.fn.dataTable; $.extend( DataTable.ext.buttons, { // A collection of column visibility buttons colvis: function ( dt, conf ) { return { extend: 'collection', text: function ( dt ) { return dt.i18n( 'buttons.colvis', 'Column visibility' ); }, className: 'buttons-colvis', buttons: [ { extend: 'columnsToggle', columns: conf.columns, columnText: conf.columnText } ] }; }, // Selected columns with individual buttons - toggle column visibility columnsToggle: function ( dt, conf ) { var columns = dt.columns( conf.columns ).indexes().map( function ( idx ) { return { extend: 'columnToggle', columns: idx, columnText: conf.columnText }; } ).toArray(); return columns; }, // Single button to toggle column visibility columnToggle: function ( dt, conf ) { return { extend: 'columnVisibility', columns: conf.columns, columnText: conf.columnText }; }, // Selected columns with individual buttons - set column visibility columnsVisibility: function ( dt, conf ) { var columns = dt.columns( conf.columns ).indexes().map( function ( idx ) { return { extend: 'columnVisibility', columns: idx, visibility: conf.visibility, columnText: conf.columnText }; } ).toArray(); return columns; }, // Single button to set column visibility columnVisibility: { columns: undefined, // column selector text: function ( dt, button, conf ) { return conf._columnText( dt, conf ); }, className: 'buttons-columnVisibility', action: function ( e, dt, button, conf ) { var col = dt.columns( conf.columns ); var curr = col.visible(); col.visible( conf.visibility !== undefined ? conf.visibility : ! (curr.length ? curr[0] : false ) ); }, init: function ( dt, button, conf ) { var that = this; button.attr( 'data-cv-idx', conf.columns ); dt .on( 'column-visibility.dt'+conf.namespace, function (e, settings) { if ( ! settings.bDestroying && settings.nTable == dt.settings()[0].nTable ) { that.active( dt.column( conf.columns ).visible() ); } } ) .on( 'column-reorder.dt'+conf.namespace, function (e, settings, details) { if ( dt.columns( conf.columns ).count() !== 1 ) { return; } // This button controls the same column index but the text for the column has // changed that.text( conf._columnText( dt, conf ) ); // Since its a different column, we need to check its visibility that.active( dt.column( conf.columns ).visible() ); } ); this.active( dt.column( conf.columns ).visible() ); }, destroy: function ( dt, button, conf ) { dt .off( 'column-visibility.dt'+conf.namespace ) .off( 'column-reorder.dt'+conf.namespace ); }, _columnText: function ( dt, conf ) { // Use DataTables' internal data structure until this is presented // is a public API. The other option is to use // `$( column(col).node() ).text()` but the node might not have been // populated when Buttons is constructed. var idx = dt.column( conf.columns ).index(); var title = dt.settings()[0].aoColumns[ idx ].sTitle; if (! title) { title = dt.column(idx).header().innerHTML; } title = title .replace(/\n/g," ") // remove new lines .replace(/<br\s*\/?>/gi, " ") // replace line breaks with spaces .replace(/<select(.*?)<\/select>/g, "") // remove select tags, including options text .replace(/<!\-\-.*?\-\->/g, "") // strip HTML comments .replace(/<.*?>/g, "") // strip HTML .replace(/^\s+|\s+$/g,""); // trim return conf.columnText ? conf.columnText( dt, idx, title ) : title; } }, colvisRestore: { className: 'buttons-colvisRestore', text: function ( dt ) { return dt.i18n( 'buttons.colvisRestore', 'Restore visibility' ); }, init: function ( dt, button, conf ) { conf._visOriginal = dt.columns().indexes().map( function ( idx ) { return dt.column( idx ).visible(); } ).toArray(); }, action: function ( e, dt, button, conf ) { dt.columns().every( function ( i ) { // Take into account that ColReorder might have disrupted our // indexes var idx = dt.colReorder && dt.colReorder.transpose ? dt.colReorder.transpose( i, 'toOriginal' ) : i; this.visible( conf._visOriginal[ idx ] ); } ); } }, colvisGroup: { className: 'buttons-colvisGroup', action: function ( e, dt, button, conf ) { dt.columns( conf.show ).visible( true, false ); dt.columns( conf.hide ).visible( false, false ); dt.columns.adjust(); }, show: [], hide: [] } } ); return DataTable.Buttons; })); PK ׁ�Zy�LFx� x� js/buttons.html5.jsnu �[��� /*! * HTML5 export buttons for Buttons and DataTables. * 2016 SpryMedia Ltd - datatables.net/license * * FileSaver.js (1.3.3) - MIT license * Copyright © 2016 Eli Grey - http://eligrey.com */ (function( factory ){ if ( typeof define === 'function' && define.amd ) { // AMD define( ['jquery', 'datatables.net', 'datatables.net-buttons'], function ( $ ) { return factory( $, window, document ); } ); } else if ( typeof exports === 'object' ) { // CommonJS module.exports = function (root, $, jszip, pdfmake) { if ( ! root ) { root = window; } if ( ! $ || ! $.fn.dataTable ) { $ = require('datatables.net')(root, $).$; } if ( ! $.fn.dataTable.Buttons ) { require('datatables.net-buttons')(root, $); } return factory( $, root, root.document, jszip, pdfmake ); }; } else { // Browser factory( jQuery, window, document ); } }(function( $, window, document, jszip, pdfmake, undefined ) { 'use strict'; var DataTable = $.fn.dataTable; // Allow the constructor to pass in JSZip and PDFMake from external requires. // Otherwise, use globally defined variables, if they are available. function _jsZip () { return jszip || window.JSZip; } function _pdfMake () { return pdfmake || window.pdfMake; } DataTable.Buttons.pdfMake = function (_) { if ( ! _ ) { return _pdfMake(); } pdfmake = _; } DataTable.Buttons.jszip = function (_) { if ( ! _ ) { return _jsZip(); } jszip = _; } /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * FileSaver.js dependency */ /*jslint bitwise: true, indent: 4, laxbreak: true, laxcomma: true, smarttabs: true, plusplus: true */ var _saveAs = (function(view) { "use strict"; // IE <10 is explicitly unsupported if (typeof view === "undefined" || typeof navigator !== "undefined" && /MSIE [1-9]\./.test(navigator.userAgent)) { return; } var doc = view.document // only get URL when necessary in case Blob.js hasn't overridden it yet , get_URL = function() { return view.URL || view.webkitURL || view; } , save_link = doc.createElementNS("http://www.w3.org/1999/xhtml", "a") , can_use_save_link = "download" in save_link , click = function(node) { var event = new MouseEvent("click"); node.dispatchEvent(event); } , is_safari = /constructor/i.test(view.HTMLElement) || view.safari , is_chrome_ios =/CriOS\/[\d]+/.test(navigator.userAgent) , throw_outside = function(ex) { (view.setImmediate || view.setTimeout)(function() { throw ex; }, 0); } , force_saveable_type = "application/octet-stream" // the Blob API is fundamentally broken as there is no "downloadfinished" event to subscribe to , arbitrary_revoke_timeout = 1000 * 40 // in ms , revoke = function(file) { var revoker = function() { if (typeof file === "string") { // file is an object URL get_URL().revokeObjectURL(file); } else { // file is a File file.remove(); } }; setTimeout(revoker, arbitrary_revoke_timeout); } , dispatch = function(filesaver, event_types, event) { event_types = [].concat(event_types); var i = event_types.length; while (i--) { var listener = filesaver["on" + event_types[i]]; if (typeof listener === "function") { try { listener.call(filesaver, event || filesaver); } catch (ex) { throw_outside(ex); } } } } , auto_bom = function(blob) { // prepend BOM for UTF-8 XML and text/* types (including HTML) // note: your browser will automatically convert UTF-16 U+FEFF to EF BB BF if (/^\s*(?:text\/\S*|application\/xml|\S*\/\S*\+xml)\s*;.*charset\s*=\s*utf-8/i.test(blob.type)) { return new Blob([String.fromCharCode(0xFEFF), blob], {type: blob.type}); } return blob; } , FileSaver = function(blob, name, no_auto_bom) { if (!no_auto_bom) { blob = auto_bom(blob); } // First try a.download, then web filesystem, then object URLs var filesaver = this , type = blob.type , force = type === force_saveable_type , object_url , dispatch_all = function() { dispatch(filesaver, "writestart progress write writeend".split(" ")); } // on any filesys errors revert to saving with object URLs , fs_error = function() { if ((is_chrome_ios || (force && is_safari)) && view.FileReader) { // Safari doesn't allow downloading of blob urls var reader = new FileReader(); reader.onloadend = function() { var url = is_chrome_ios ? reader.result : reader.result.replace(/^data:[^;]*;/, 'data:attachment/file;'); var popup = view.open(url, '_blank'); if(!popup) view.location.href = url; url=undefined; // release reference before dispatching filesaver.readyState = filesaver.DONE; dispatch_all(); }; reader.readAsDataURL(blob); filesaver.readyState = filesaver.INIT; return; } // don't create more object URLs than needed if (!object_url) { object_url = get_URL().createObjectURL(blob); } if (force) { view.location.href = object_url; } else { var opened = view.open(object_url, "_blank"); if (!opened) { // Apple does not allow window.open, see https://developer.apple.com/library/safari/documentation/Tools/Conceptual/SafariExtensionGuide/WorkingwithWindowsandTabs/WorkingwithWindowsandTabs.html view.location.href = object_url; } } filesaver.readyState = filesaver.DONE; dispatch_all(); revoke(object_url); } ; filesaver.readyState = filesaver.INIT; if (can_use_save_link) { object_url = get_URL().createObjectURL(blob); setTimeout(function() { save_link.href = object_url; save_link.download = name; click(save_link); dispatch_all(); revoke(object_url); filesaver.readyState = filesaver.DONE; }); return; } fs_error(); } , FS_proto = FileSaver.prototype , saveAs = function(blob, name, no_auto_bom) { return new FileSaver(blob, name || blob.name || "download", no_auto_bom); } ; // IE 10+ (native saveAs) if (typeof navigator !== "undefined" && navigator.msSaveOrOpenBlob) { return function(blob, name, no_auto_bom) { name = name || blob.name || "download"; if (!no_auto_bom) { blob = auto_bom(blob); } return navigator.msSaveOrOpenBlob(blob, name); }; } FS_proto.abort = function(){}; FS_proto.readyState = FS_proto.INIT = 0; FS_proto.WRITING = 1; FS_proto.DONE = 2; FS_proto.error = FS_proto.onwritestart = FS_proto.onprogress = FS_proto.onwrite = FS_proto.onabort = FS_proto.onerror = FS_proto.onwriteend = null; return saveAs; }( typeof self !== "undefined" && self || typeof window !== "undefined" && window || this.content )); // Expose file saver on the DataTables API. Can't attach to `DataTables.Buttons` // since this file can be loaded before Button's core! DataTable.fileSave = _saveAs; /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Local (private) functions */ /** * Get the sheet name for Excel exports. * * @param {object} config Button configuration */ var _sheetname = function ( config ) { var sheetName = 'Sheet1'; if ( config.sheetName ) { sheetName = config.sheetName.replace(/[\[\]\*\/\\\?\:]/g, ''); } return sheetName; }; /** * Get the newline character(s) * * @param {object} config Button configuration * @return {string} Newline character */ var _newLine = function ( config ) { return config.newline ? config.newline : navigator.userAgent.match(/Windows/) ? '\r\n' : '\n'; }; /** * Combine the data from the `buttons.exportData` method into a string that * will be used in the export file. * * @param {DataTable.Api} dt DataTables API instance * @param {object} config Button configuration * @return {object} The data to export */ var _exportData = function ( dt, config ) { var newLine = _newLine( config ); var data = dt.buttons.exportData( config.exportOptions ); var boundary = config.fieldBoundary; var separator = config.fieldSeparator; var reBoundary = new RegExp( boundary, 'g' ); var escapeChar = config.escapeChar !== undefined ? config.escapeChar : '\\'; var join = function ( a ) { var s = ''; // If there is a field boundary, then we might need to escape it in // the source data for ( var i=0, ien=a.length ; i<ien ; i++ ) { if ( i > 0 ) { s += separator; } s += boundary ? boundary + ('' + a[i]).replace( reBoundary, escapeChar+boundary ) + boundary : a[i]; } return s; }; var header = config.header ? join( data.header )+newLine : ''; var footer = config.footer && data.footer ? newLine+join( data.footer ) : ''; var body = []; for ( var i=0, ien=data.body.length ; i<ien ; i++ ) { body.push( join( data.body[i] ) ); } return { str: header + body.join( newLine ) + footer, rows: body.length }; }; /** * Older versions of Safari (prior to tech preview 18) don't support the * download option required. * * @return {Boolean} `true` if old Safari */ var _isDuffSafari = function () { var safari = navigator.userAgent.indexOf('Safari') !== -1 && navigator.userAgent.indexOf('Chrome') === -1 && navigator.userAgent.indexOf('Opera') === -1; if ( ! safari ) { return false; } var version = navigator.userAgent.match( /AppleWebKit\/(\d+\.\d+)/ ); if ( version && version.length > 1 && version[1]*1 < 603.1 ) { return true; } return false; }; /** * Convert from numeric position to letter for column names in Excel * @param {int} n Column number * @return {string} Column letter(s) name */ function createCellPos( n ){ var ordA = 'A'.charCodeAt(0); var ordZ = 'Z'.charCodeAt(0); var len = ordZ - ordA + 1; var s = ""; while( n >= 0 ) { s = String.fromCharCode(n % len + ordA) + s; n = Math.floor(n / len) - 1; } return s; } try { var _serialiser = new XMLSerializer(); var _ieExcel; } catch (t) {} /** * Recursively add XML files from an object's structure to a ZIP file. This * allows the XSLX file to be easily defined with an object's structure matching * the files structure. * * @param {JSZip} zip ZIP package * @param {object} obj Object to add (recursive) */ function _addToZip( zip, obj ) { if ( _ieExcel === undefined ) { // Detect if we are dealing with IE's _awful_ serialiser by seeing if it // drop attributes _ieExcel = _serialiser .serializeToString( ( new window.DOMParser() ).parseFromString( excelStrings['xl/worksheets/sheet1.xml'], 'text/xml' ) ) .indexOf( 'xmlns:r' ) === -1; } $.each( obj, function ( name, val ) { if ( $.isPlainObject( val ) ) { var newDir = zip.folder( name ); _addToZip( newDir, val ); } else { if ( _ieExcel ) { // IE's XML serialiser will drop some name space attributes from // from the root node, so we need to save them. Do this by // replacing the namespace nodes with a regular attribute that // we convert back when serialised. Edge does not have this // issue var worksheet = val.childNodes[0]; var i, ien; var attrs = []; for ( i=worksheet.attributes.length-1 ; i>=0 ; i-- ) { var attrName = worksheet.attributes[i].nodeName; var attrValue = worksheet.attributes[i].nodeValue; if ( attrName.indexOf( ':' ) !== -1 ) { attrs.push( { name: attrName, value: attrValue } ); worksheet.removeAttribute( attrName ); } } for ( i=0, ien=attrs.length ; i<ien ; i++ ) { var attr = val.createAttribute( attrs[i].name.replace( ':', '_dt_b_namespace_token_' ) ); attr.value = attrs[i].value; worksheet.setAttributeNode( attr ); } } var str = _serialiser.serializeToString(val); // Fix IE's XML if ( _ieExcel ) { // IE doesn't include the XML declaration if ( str.indexOf( '<?xml' ) === -1 ) { str = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+str; } // Return namespace attributes to being as such str = str.replace( /_dt_b_namespace_token_/g, ':' ); // Remove testing name space that IE puts into the space preserve attr str = str.replace( /xmlns:NS[\d]+="" NS[\d]+:/g, '' ); } // Safari, IE and Edge will put empty name space attributes onto // various elements making them useless. This strips them out str = str.replace( /<([^<>]*?) xmlns=""([^<>]*?)>/g, '<$1 $2>' ); zip.file( name, str ); } } ); } /** * Create an XML node and add any children, attributes, etc without needing to * be verbose in the DOM. * * @param {object} doc XML document * @param {string} nodeName Node name * @param {object} opts Options - can be `attr` (attributes), `children` * (child nodes) and `text` (text content) * @return {node} Created node */ function _createNode( doc, nodeName, opts ) { var tempNode = doc.createElement( nodeName ); if ( opts ) { if ( opts.attr ) { $(tempNode).attr( opts.attr ); } if ( opts.children ) { $.each( opts.children, function ( key, value ) { tempNode.appendChild( value ); } ); } if ( opts.text !== null && opts.text !== undefined ) { tempNode.appendChild( doc.createTextNode( opts.text ) ); } } return tempNode; } /** * Get the width for an Excel column based on the contents of that column * @param {object} data Data for export * @param {int} col Column index * @return {int} Column width */ function _excelColWidth( data, col ) { var max = data.header[col].length; var len, lineSplit, str; if ( data.footer && data.footer[col].length > max ) { max = data.footer[col].length; } for ( var i=0, ien=data.body.length ; i<ien ; i++ ) { var point = data.body[i][col]; str = point !== null && point !== undefined ? point.toString() : ''; // If there is a newline character, workout the width of the column // based on the longest line in the string if ( str.indexOf('\n') !== -1 ) { lineSplit = str.split('\n'); lineSplit.sort( function (a, b) { return b.length - a.length; } ); len = lineSplit[0].length; } else { len = str.length; } if ( len > max ) { max = len; } // Max width rather than having potentially massive column widths if ( max > 40 ) { return 54; // 40 * 1.35 } } max *= 1.35; // And a min width return max > 6 ? max : 6; } // Excel - Pre-defined strings to build a basic XLSX file var excelStrings = { "_rels/.rels": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">'+ '<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="xl/workbook.xml"/>'+ '</Relationships>', "xl/_rels/workbook.xml.rels": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships">'+ '<Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/>'+ '<Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/>'+ '</Relationships>', "[Content_Types].xml": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<Types xmlns="http://schemas.openxmlformats.org/package/2006/content-types">'+ '<Default Extension="xml" ContentType="application/xml" />'+ '<Default Extension="rels" ContentType="application/vnd.openxmlformats-package.relationships+xml" />'+ '<Default Extension="jpeg" ContentType="image/jpeg" />'+ '<Override PartName="/xl/workbook.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml" />'+ '<Override PartName="/xl/worksheets/sheet1.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.worksheet+xml" />'+ '<Override PartName="/xl/styles.xml" ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.styles+xml" />'+ '</Types>', "xl/workbook.xml": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<workbook xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships">'+ '<fileVersion appName="xl" lastEdited="5" lowestEdited="5" rupBuild="24816"/>'+ '<workbookPr showInkAnnotation="0" autoCompressPictures="0"/>'+ '<bookViews>'+ '<workbookView xWindow="0" yWindow="0" windowWidth="25600" windowHeight="19020" tabRatio="500"/>'+ '</bookViews>'+ '<sheets>'+ '<sheet name="Sheet1" sheetId="1" r:id="rId1"/>'+ '</sheets>'+ '<definedNames/>'+ '</workbook>', "xl/worksheets/sheet1.xml": '<?xml version="1.0" encoding="UTF-8" standalone="yes"?>'+ '<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">'+ '<sheetData/>'+ '<mergeCells count="0"/>'+ '</worksheet>', "xl/styles.xml": '<?xml version="1.0" encoding="UTF-8"?>'+ '<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">'+ '<numFmts count="6">'+ '<numFmt numFmtId="164" formatCode="#,##0.00_-\ [$$-45C]"/>'+ '<numFmt numFmtId="165" formatCode=""£"#,##0.00"/>'+ '<numFmt numFmtId="166" formatCode="[$€-2]\ #,##0.00"/>'+ '<numFmt numFmtId="167" formatCode="0.0%"/>'+ '<numFmt numFmtId="168" formatCode="#,##0;(#,##0)"/>'+ '<numFmt numFmtId="169" formatCode="#,##0.00;(#,##0.00)"/>'+ '</numFmts>'+ '<fonts count="5" x14ac:knownFonts="1">'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '</font>'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '<color rgb="FFFFFFFF" />'+ '</font>'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '<b />'+ '</font>'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '<i />'+ '</font>'+ '<font>'+ '<sz val="11" />'+ '<name val="Calibri" />'+ '<u />'+ '</font>'+ '</fonts>'+ '<fills count="6">'+ '<fill>'+ '<patternFill patternType="none" />'+ '</fill>'+ '<fill>'+ // Excel appears to use this as a dotted background regardless of values but '<patternFill patternType="none" />'+ // to be valid to the schema, use a patternFill '</fill>'+ '<fill>'+ '<patternFill patternType="solid">'+ '<fgColor rgb="FFD9D9D9" />'+ '<bgColor indexed="64" />'+ '</patternFill>'+ '</fill>'+ '<fill>'+ '<patternFill patternType="solid">'+ '<fgColor rgb="FFD99795" />'+ '<bgColor indexed="64" />'+ '</patternFill>'+ '</fill>'+ '<fill>'+ '<patternFill patternType="solid">'+ '<fgColor rgb="ffc6efce" />'+ '<bgColor indexed="64" />'+ '</patternFill>'+ '</fill>'+ '<fill>'+ '<patternFill patternType="solid">'+ '<fgColor rgb="ffc6cfef" />'+ '<bgColor indexed="64" />'+ '</patternFill>'+ '</fill>'+ '</fills>'+ '<borders count="2">'+ '<border>'+ '<left />'+ '<right />'+ '<top />'+ '<bottom />'+ '<diagonal />'+ '</border>'+ '<border diagonalUp="false" diagonalDown="false">'+ '<left style="thin">'+ '<color auto="1" />'+ '</left>'+ '<right style="thin">'+ '<color auto="1" />'+ '</right>'+ '<top style="thin">'+ '<color auto="1" />'+ '</top>'+ '<bottom style="thin">'+ '<color auto="1" />'+ '</bottom>'+ '<diagonal />'+ '</border>'+ '</borders>'+ '<cellStyleXfs count="1">'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" />'+ '</cellStyleXfs>'+ '<cellXfs count="68">'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="2" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="3" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="4" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="5" borderId="0" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="0" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="2" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="3" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="4" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="1" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="2" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="3" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="4" fillId="5" borderId="1" applyFont="1" applyFill="1" applyBorder="1"/>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment horizontal="left"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment horizontal="center"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment horizontal="right"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment horizontal="fill"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment textRotation="90"/>'+ '</xf>'+ '<xf numFmtId="0" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyAlignment="1">'+ '<alignment wrapText="1"/>'+ '</xf>'+ '<xf numFmtId="9" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="164" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="165" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="166" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="167" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="168" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="169" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="3" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="4" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="1" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="2" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '<xf numFmtId="14" fontId="0" fillId="0" borderId="0" applyFont="1" applyFill="1" applyBorder="1" xfId="0" applyNumberFormat="1"/>'+ '</cellXfs>'+ '<cellStyles count="1">'+ '<cellStyle name="Normal" xfId="0" builtinId="0" />'+ '</cellStyles>'+ '<dxfs count="0" />'+ '<tableStyles count="0" defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotStyleMedium4" />'+ '</styleSheet>' }; // Note we could use 3 `for` loops for the styles, but when gzipped there is // virtually no difference in size, since the above can be easily compressed // Pattern matching for special number formats. Perhaps this should be exposed // via an API in future? // Ref: section 3.8.30 - built in formatters in open spreadsheet // https://www.ecma-international.org/news/TC45_current_work/Office%20Open%20XML%20Part%204%20-%20Markup%20Language%20Reference.pdf var _excelSpecials = [ { match: /^\-?\d+\.\d%$/, style: 60, fmt: function (d) { return d/100; } }, // Precent with d.p. { match: /^\-?\d+\.?\d*%$/, style: 56, fmt: function (d) { return d/100; } }, // Percent { match: /^\-?\$[\d,]+.?\d*$/, style: 57 }, // Dollars { match: /^\-?£[\d,]+.?\d*$/, style: 58 }, // Pounds { match: /^\-?€[\d,]+.?\d*$/, style: 59 }, // Euros { match: /^\-?\d+$/, style: 65 }, // Numbers without thousand separators { match: /^\-?\d+\.\d{2}$/, style: 66 }, // Numbers 2 d.p. without thousands separators { match: /^\([\d,]+\)$/, style: 61, fmt: function (d) { return -1 * d.replace(/[\(\)]/g, ''); } }, // Negative numbers indicated by brackets { match: /^\([\d,]+\.\d{2}\)$/, style: 62, fmt: function (d) { return -1 * d.replace(/[\(\)]/g, ''); } }, // Negative numbers indicated by brackets - 2d.p. { match: /^\-?[\d,]+$/, style: 63 }, // Numbers with thousand separators { match: /^\-?[\d,]+\.\d{2}$/, style: 64 }, { match: /^[\d]{4}\-[\d]{2}\-[\d]{2}$/, style: 67, fmt: function (d) {return Math.round(25569 + (Date.parse(d) / (86400 * 1000)));}} //Date yyyy-mm-dd ]; /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Buttons */ // // Copy to clipboard // DataTable.ext.buttons.copyHtml5 = { className: 'buttons-copy buttons-html5', text: function ( dt ) { return dt.i18n( 'buttons.copy', 'Copy' ); }, action: function ( e, dt, button, config ) { this.processing( true ); var that = this; var exportData = _exportData( dt, config ); var info = dt.buttons.exportInfo( config ); var newline = _newLine(config); var output = exportData.str; var hiddenDiv = $('<div/>') .css( { height: 1, width: 1, overflow: 'hidden', position: 'fixed', top: 0, left: 0 } ); if ( info.title ) { output = info.title + newline + newline + output; } if ( info.messageTop ) { output = info.messageTop + newline + newline + output; } if ( info.messageBottom ) { output = output + newline + newline + info.messageBottom; } if ( config.customize ) { output = config.customize( output, config, dt ); } var textarea = $('<textarea readonly/>') .val( output ) .appendTo( hiddenDiv ); // For browsers that support the copy execCommand, try to use it if ( document.queryCommandSupported('copy') ) { hiddenDiv.appendTo( dt.table().container() ); textarea[0].focus(); textarea[0].select(); try { var successful = document.execCommand( 'copy' ); hiddenDiv.remove(); if (successful) { dt.buttons.info( dt.i18n( 'buttons.copyTitle', 'Copy to clipboard' ), dt.i18n( 'buttons.copySuccess', { 1: 'Copied one row to clipboard', _: 'Copied %d rows to clipboard' }, exportData.rows ), 2000 ); this.processing( false ); return; } } catch (t) {} } // Otherwise we show the text box and instruct the user to use it var message = $('<span>'+dt.i18n( 'buttons.copyKeys', 'Press <i>ctrl</i> or <i>\u2318</i> + <i>C</i> to copy the table data<br>to your system clipboard.<br><br>'+ 'To cancel, click this message or press escape.' )+'</span>' ) .append( hiddenDiv ); dt.buttons.info( dt.i18n( 'buttons.copyTitle', 'Copy to clipboard' ), message, 0 ); // Select the text so when the user activates their system clipboard // it will copy that text textarea[0].focus(); textarea[0].select(); // Event to hide the message when the user is done var container = $(message).closest('.dt-button-info'); var close = function () { container.off( 'click.buttons-copy' ); $(document).off( '.buttons-copy' ); dt.buttons.info( false ); }; container.on( 'click.buttons-copy', close ); $(document) .on( 'keydown.buttons-copy', function (e) { if ( e.keyCode === 27 ) { // esc close(); that.processing( false ); } } ) .on( 'copy.buttons-copy cut.buttons-copy', function () { close(); that.processing( false ); } ); }, exportOptions: {}, fieldSeparator: '\t', fieldBoundary: '', header: true, footer: false, title: '*', messageTop: '*', messageBottom: '*' }; // // CSV export // DataTable.ext.buttons.csvHtml5 = { bom: false, className: 'buttons-csv buttons-html5', available: function () { return window.FileReader !== undefined && window.Blob; }, text: function ( dt ) { return dt.i18n( 'buttons.csv', 'CSV' ); }, action: function ( e, dt, button, config ) { this.processing( true ); // Set the text var output = _exportData( dt, config ).str; var info = dt.buttons.exportInfo(config); var charset = config.charset; if ( config.customize ) { output = config.customize( output, config, dt ); } if ( charset !== false ) { if ( ! charset ) { charset = document.characterSet || document.charset; } if ( charset ) { charset = ';charset='+charset; } } else { charset = ''; } if ( config.bom ) { output = '\ufeff' + output; } _saveAs( new Blob( [output], {type: 'text/csv'+charset} ), info.filename, true ); this.processing( false ); }, filename: '*', extension: '.csv', exportOptions: {}, fieldSeparator: ',', fieldBoundary: '"', escapeChar: '"', charset: null, header: true, footer: false }; // // Excel (xlsx) export // DataTable.ext.buttons.excelHtml5 = { className: 'buttons-excel buttons-html5', available: function () { return window.FileReader !== undefined && _jsZip() !== undefined && ! _isDuffSafari() && _serialiser; }, text: function ( dt ) { return dt.i18n( 'buttons.excel', 'Excel' ); }, action: function ( e, dt, button, config ) { this.processing( true ); var that = this; var rowPos = 0; var dataStartRow, dataEndRow; var getXml = function ( type ) { var str = excelStrings[ type ]; //str = str.replace( /xmlns:/g, 'xmlns_' ).replace( /mc:/g, 'mc_' ); return $.parseXML( str ); }; var rels = getXml('xl/worksheets/sheet1.xml'); var relsGet = rels.getElementsByTagName( "sheetData" )[0]; var xlsx = { _rels: { ".rels": getXml('_rels/.rels') }, xl: { _rels: { "workbook.xml.rels": getXml('xl/_rels/workbook.xml.rels') }, "workbook.xml": getXml('xl/workbook.xml'), "styles.xml": getXml('xl/styles.xml'), "worksheets": { "sheet1.xml": rels } }, "[Content_Types].xml": getXml('[Content_Types].xml') }; var data = dt.buttons.exportData( config.exportOptions ); var currentRow, rowNode; var addRow = function ( row ) { currentRow = rowPos+1; rowNode = _createNode( rels, "row", { attr: {r:currentRow} } ); for ( var i=0, ien=row.length ; i<ien ; i++ ) { // Concat both the Cell Columns as a letter and the Row of the cell. var cellId = createCellPos(i) + '' + currentRow; var cell = null; // For null, undefined of blank cell, continue so it doesn't create the _createNode if ( row[i] === null || row[i] === undefined || row[i] === '' ) { if ( config.createEmptyCells === true ) { row[i] = ''; } else { continue; } } var originalContent = row[i]; row[i] = typeof row[i].trim === 'function' ? row[i].trim() : row[i]; // Special number formatting options for ( var j=0, jen=_excelSpecials.length ; j<jen ; j++ ) { var special = _excelSpecials[j]; // TODO Need to provide the ability for the specials to say // if they are returning a string, since at the moment it is // assumed to be a number if ( row[i].match && ! row[i].match(/^0\d+/) && row[i].match( special.match ) ) { var val = row[i].replace(/[^\d\.\-]/g, ''); if ( special.fmt ) { val = special.fmt( val ); } cell = _createNode( rels, 'c', { attr: { r: cellId, s: special.style }, children: [ _createNode( rels, 'v', { text: val } ) ] } ); break; } } if ( ! cell ) { if ( typeof row[i] === 'number' || ( row[i].match && row[i].match(/^-?\d+(\.\d+)?$/) && ! row[i].match(/^0\d+/) ) ) { // Detect numbers - don't match numbers with leading zeros // or a negative anywhere but the start cell = _createNode( rels, 'c', { attr: { t: 'n', r: cellId }, children: [ _createNode( rels, 'v', { text: row[i] } ) ] } ); } else { // String output - replace non standard characters for text output var text = ! originalContent.replace ? originalContent : originalContent.replace(/[\x00-\x09\x0B\x0C\x0E-\x1F\x7F-\x9F]/g, ''); cell = _createNode( rels, 'c', { attr: { t: 'inlineStr', r: cellId }, children:{ row: _createNode( rels, 'is', { children: { row: _createNode( rels, 't', { text: text, attr: { 'xml:space': 'preserve' } } ) } } ) } } ); } } rowNode.appendChild( cell ); } relsGet.appendChild(rowNode); rowPos++; }; if ( config.customizeData ) { config.customizeData( data ); } var mergeCells = function ( row, colspan ) { var mergeCells = $('mergeCells', rels); mergeCells[0].appendChild( _createNode( rels, 'mergeCell', { attr: { ref: 'A'+row+':'+createCellPos(colspan)+row } } ) ); mergeCells.attr( 'count', parseFloat(mergeCells.attr( 'count' ))+1 ); $('row:eq('+(row-1)+') c', rels).attr( 's', '51' ); // centre }; // Title and top messages var exportInfo = dt.buttons.exportInfo( config ); if ( exportInfo.title ) { addRow( [exportInfo.title], rowPos ); mergeCells( rowPos, data.header.length-1 ); } if ( exportInfo.messageTop ) { addRow( [exportInfo.messageTop], rowPos ); mergeCells( rowPos, data.header.length-1 ); } // Table itself if ( config.header ) { addRow( data.header, rowPos ); $('row:last c', rels).attr( 's', '2' ); // bold } dataStartRow = rowPos; for ( var n=0, ie=data.body.length ; n<ie ; n++ ) { addRow( data.body[n], rowPos ); } dataEndRow = rowPos; if ( config.footer && data.footer ) { addRow( data.footer, rowPos); $('row:last c', rels).attr( 's', '2' ); // bold } // Below the table if ( exportInfo.messageBottom ) { addRow( [exportInfo.messageBottom], rowPos ); mergeCells( rowPos, data.header.length-1 ); } // Set column widths var cols = _createNode( rels, 'cols' ); $('worksheet', rels).prepend( cols ); for ( var i=0, ien=data.header.length ; i<ien ; i++ ) { cols.appendChild( _createNode( rels, 'col', { attr: { min: i+1, max: i+1, width: _excelColWidth( data, i ), customWidth: 1 } } ) ); } // Workbook modifications var workbook = xlsx.xl['workbook.xml']; $( 'sheets sheet', workbook ).attr( 'name', _sheetname( config ) ); // Auto filter for columns if ( config.autoFilter ) { $('mergeCells', rels).before( _createNode( rels, 'autoFilter', { attr: { ref: 'A'+dataStartRow+':'+createCellPos(data.header.length-1)+dataEndRow } } ) ); $('definedNames', workbook).append( _createNode( workbook, 'definedName', { attr: { name: '_xlnm._FilterDatabase', localSheetId: '0', hidden: 1 }, text: _sheetname(config)+'!$A$'+dataStartRow+':'+createCellPos(data.header.length-1)+dataEndRow } ) ); } // Let the developer customise the document if they want to if ( config.customize ) { config.customize( xlsx, config, dt ); } // Excel doesn't like an empty mergeCells tag if ( $('mergeCells', rels).children().length === 0 ) { $('mergeCells', rels).remove(); } var jszip = _jsZip(); var zip = new jszip(); var zipConfig = { type: 'blob', mimeType: 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' }; _addToZip( zip, xlsx ); if ( zip.generateAsync ) { // JSZip 3+ zip .generateAsync( zipConfig ) .then( function ( blob ) { _saveAs( blob, exportInfo.filename ); that.processing( false ); } ); } else { // JSZip 2.5 _saveAs( zip.generate( zipConfig ), exportInfo.filename ); this.processing( false ); } }, filename: '*', extension: '.xlsx', exportOptions: {}, header: true, footer: false, title: '*', messageTop: '*', messageBottom: '*', createEmptyCells: false, autoFilter: false, sheetName: '' }; // // PDF export - using pdfMake - http://pdfmake.org // DataTable.ext.buttons.pdfHtml5 = { className: 'buttons-pdf buttons-html5', available: function () { return window.FileReader !== undefined && _pdfMake(); }, text: function ( dt ) { return dt.i18n( 'buttons.pdf', 'PDF' ); }, action: function ( e, dt, button, config ) { this.processing( true ); var that = this; var data = dt.buttons.exportData( config.exportOptions ); var info = dt.buttons.exportInfo( config ); var rows = []; if ( config.header ) { rows.push( $.map( data.header, function ( d ) { return { text: typeof d === 'string' ? d : d+'', style: 'tableHeader' }; } ) ); } for ( var i=0, ien=data.body.length ; i<ien ; i++ ) { rows.push( $.map( data.body[i], function ( d ) { if ( d === null || d === undefined ) { d = ''; } return { text: typeof d === 'string' ? d : d+'', style: i % 2 ? 'tableBodyEven' : 'tableBodyOdd' }; } ) ); } if ( config.footer && data.footer) { rows.push( $.map( data.footer, function ( d ) { return { text: typeof d === 'string' ? d : d+'', style: 'tableFooter' }; } ) ); } var doc = { pageSize: config.pageSize, pageOrientation: config.orientation, content: [ { table: { headerRows: 1, body: rows }, layout: 'noBorders' } ], styles: { tableHeader: { bold: true, fontSize: 11, color: 'white', fillColor: '#2d4154', alignment: 'center' }, tableBodyEven: {}, tableBodyOdd: { fillColor: '#f3f3f3' }, tableFooter: { bold: true, fontSize: 11, color: 'white', fillColor: '#2d4154' }, title: { alignment: 'center', fontSize: 15 }, message: {} }, defaultStyle: { fontSize: 10 } }; if ( info.messageTop ) { doc.content.unshift( { text: info.messageTop, style: 'message', margin: [ 0, 0, 0, 12 ] } ); } if ( info.messageBottom ) { doc.content.push( { text: info.messageBottom, style: 'message', margin: [ 0, 0, 0, 12 ] } ); } if ( info.title ) { doc.content.unshift( { text: info.title, style: 'title', margin: [ 0, 0, 0, 12 ] } ); } if ( config.customize ) { config.customize( doc, config, dt ); } var pdf = _pdfMake().createPdf( doc ); if ( config.download === 'open' && ! _isDuffSafari() ) { pdf.open(); } else { pdf.download( info.filename ); } this.processing( false ); }, title: '*', filename: '*', extension: '.pdf', exportOptions: {}, orientation: 'portrait', pageSize: 'A4', header: true, footer: false, messageTop: '*', messageBottom: '*', customize: null, download: 'download' }; return DataTable.Buttons; })); PK ׁ�Zf� js/buttons.bootstrap4.min.jsnu �[��� /*! Bootstrap integration for DataTables' Buttons ©2016 SpryMedia Ltd - datatables.net/license */ (function(b){"function"===typeof define&&define.amd?define(["jquery","datatables.net-bs4","datatables.net-buttons"],function(a){return b(a,window,document)}):"object"===typeof exports?module.exports=function(a,c){a||(a=window);if(!c||!c.fn.dataTable)c=require("datatables.net-bs4")(a,c).$;c.fn.dataTable.Buttons||require("datatables.net-buttons")(a,c);return b(c,a,a.document)}:b(jQuery,window,document)})(function(b){var a=b.fn.dataTable;b.extend(!0,a.Buttons.defaults,{dom:{container:{className:"dt-buttons btn-group flex-wrap"}, button:{className:"btn btn-secondary"},collection:{tag:"div",className:"dropdown-menu",button:{tag:"a",className:"dt-button dropdown-item",active:"active",disabled:"disabled"}}},buttonCreated:function(a,d){return a.buttons?b('<div class="btn-group"/>').append(d):d}});a.ext.buttons.collection.className+=" dropdown-toggle";a.ext.buttons.collection.rightAlignClassName="dropdown-menu-right";return a.Buttons}); PK ׁ�Z�0,� js/buttons.colVis.min.jsnu �[��� (function(g){"function"===typeof define&&define.amd?define(["jquery","datatables.net","datatables.net-buttons"],function(e){return g(e,window,document)}):"object"===typeof exports?module.exports=function(e,f){e||(e=window);if(!f||!f.fn.dataTable)f=require("datatables.net")(e,f).$;f.fn.dataTable.Buttons||require("datatables.net-buttons")(e,f);return g(f,e,e.document)}:g(jQuery,window,document)})(function(g,e,f,h){e=g.fn.dataTable;g.extend(e.ext.buttons,{colvis:function(a,b){return{extend:"collection", text:function(b){return b.i18n("buttons.colvis","Column visibility")},className:"buttons-colvis",buttons:[{extend:"columnsToggle",columns:b.columns,columnText:b.columnText}]}},columnsToggle:function(a,b){return a.columns(b.columns).indexes().map(function(a){return{extend:"columnToggle",columns:a,columnText:b.columnText}}).toArray()},columnToggle:function(a,b){return{extend:"columnVisibility",columns:b.columns,columnText:b.columnText}},columnsVisibility:function(a,b){return a.columns(b.columns).indexes().map(function(a){return{extend:"columnVisibility", columns:a,visibility:b.visibility,columnText:b.columnText}}).toArray()},columnVisibility:{columns:h,text:function(a,b,c){return c._columnText(a,c)},className:"buttons-columnVisibility",action:function(a,b,c,d){a=b.columns(d.columns);b=a.visible();a.visible(d.visibility!==h?d.visibility:!(b.length&&b[0]))},init:function(a,b,c){var d=this;b.attr("data-cv-idx",c.columns);a.on("column-visibility.dt"+c.namespace,function(b,e){!e.bDestroying&&e.nTable==a.settings()[0].nTable&&d.active(a.column(c.columns).visible())}).on("column-reorder.dt"+ c.namespace,function(){1===a.columns(c.columns).count()&&(d.text(c._columnText(a,c)),d.active(a.column(c.columns).visible()))});this.active(a.column(c.columns).visible())},destroy:function(a,b,c){a.off("column-visibility.dt"+c.namespace).off("column-reorder.dt"+c.namespace)},_columnText:function(a,b){var c=a.column(b.columns).index(),d=a.settings()[0].aoColumns[c].sTitle;d||(d=a.column(c).header().innerHTML);d=d.replace(/\n/g," ").replace(/<br\s*\/?>/gi," ").replace(/<select(.*?)<\/select>/g,"").replace(/<!\-\-.*?\-\->/g, "").replace(/<.*?>/g,"").replace(/^\s+|\s+$/g,"");return b.columnText?b.columnText(a,c,d):d}},colvisRestore:{className:"buttons-colvisRestore",text:function(a){return a.i18n("buttons.colvisRestore","Restore visibility")},init:function(a,b,c){c._visOriginal=a.columns().indexes().map(function(b){return a.column(b).visible()}).toArray()},action:function(a,b,c,d){b.columns().every(function(a){a=b.colReorder&&b.colReorder.transpose?b.colReorder.transpose(a,"toOriginal"):a;this.visible(d._visOriginal[a])})}}, colvisGroup:{className:"buttons-colvisGroup",action:function(a,b,c,d){b.columns(d.show).visible(!0,!1);b.columns(d.hide).visible(!1,!1);b.columns.adjust()},show:[],hide:[]}});return e.Buttons}); PK ׁ�Z��צ js/buttons.bootstrap4.jsnu �[��� /*! Bootstrap integration for DataTables' Buttons * ©2016 SpryMedia Ltd - datatables.net/license */ (function( factory ){ if ( typeof define === 'function' && define.amd ) { // AMD define( ['jquery', 'datatables.net-bs4', 'datatables.net-buttons'], function ( $ ) { return factory( $, window, document ); } ); } else if ( typeof exports === 'object' ) { // CommonJS module.exports = function (root, $) { if ( ! root ) { root = window; } if ( ! $ || ! $.fn.dataTable ) { $ = require('datatables.net-bs4')(root, $).$; } if ( ! $.fn.dataTable.Buttons ) { require('datatables.net-buttons')(root, $); } return factory( $, root, root.document ); }; } else { // Browser factory( jQuery, window, document ); } }(function( $, window, document, undefined ) { 'use strict'; var DataTable = $.fn.dataTable; $.extend( true, DataTable.Buttons.defaults, { dom: { container: { className: 'dt-buttons btn-group flex-wrap' }, button: { className: 'btn btn-secondary' }, collection: { tag: 'div', className: 'dropdown-menu', button: { tag: 'a', className: 'dt-button dropdown-item', active: 'active', disabled: 'disabled' } } }, buttonCreated: function ( config, button ) { return config.buttons ? $('<div class="btn-group"/>').append(button) : button; } } ); DataTable.ext.buttons.collection.className += ' dropdown-toggle'; DataTable.ext.buttons.collection.rightAlignClassName = 'dropdown-menu-right'; return DataTable.Buttons; })); PK ׁ�Z+�o� � js/buttons.print.min.jsnu �[��� (function(e){"function"===typeof define&&define.amd?define(["jquery","datatables.net","datatables.net-buttons"],function(f){return e(f,window,document)}):"object"===typeof exports?module.exports=function(f,a){f||(f=window);if(!a||!a.fn.dataTable)a=require("datatables.net")(f,a).$;a.fn.dataTable.Buttons||require("datatables.net-buttons")(f,a);return e(a,f,f.document)}:e(jQuery,window,document)})(function(e,f,a,n){var i=e.fn.dataTable,c=a.createElement("a"),m=function(b){c.href=b;b=c.host;-1===b.indexOf("/")&& 0!==c.pathname.indexOf("/")&&(b+="/");return c.protocol+"//"+b+c.pathname+c.search};i.ext.buttons.print={className:"buttons-print",text:function(b){return b.i18n("buttons.print","Print")},action:function(b,a,c,h){var b=a.buttons.exportData(e.extend({decodeEntities:!1},h.exportOptions)),c=a.buttons.exportInfo(h),i=a.columns(h.exportOptions.columns).flatten().map(function(b){return a.settings()[0].aoColumns[a.column(b).index()].sClass}).toArray(),k=function(b,a){for(var d="<tr>",c=0,e=b.length;c<e;c++)d+= "<"+a+" "+(i[c]?'class="'+i[c]+'"':"")+">"+(null===b[c]||b[c]===n?"":b[c])+"</"+a+">";return d+"</tr>"},d='<table class="'+a.table().node().className+'">';h.header&&(d+="<thead>"+k(b.header,"th")+"</thead>");for(var d=d+"<tbody>",l=0,o=b.body.length;l<o;l++)d+=k(b.body[l],"td");d+="</tbody>";h.footer&&b.footer&&(d+="<tfoot>"+k(b.footer,"th")+"</tfoot>");var d=d+"</table>",g=f.open("","");g.document.close();var j="<title>"+c.title+"</title>";e("style, link").each(function(){var b=j,a=e(this).clone()[0]; "link"===a.nodeName.toLowerCase()&&(a.href=m(a.href));j=b+a.outerHTML});try{g.document.head.innerHTML=j}catch(p){e(g.document.head).html(j)}g.document.body.innerHTML="<h1>"+c.title+"</h1><div>"+(c.messageTop||"")+"</div>"+d+"<div>"+(c.messageBottom||"")+"</div>";e(g.document.body).addClass("dt-print-view");e("img",g.document.body).each(function(b,a){a.setAttribute("src",m(a.getAttribute("src")))});h.customize&&h.customize(g,h,a);b=function(){h.autoPrint&&(g.print(),g.close())};navigator.userAgent.match(/Trident\/\d.\d/)? b():g.setTimeout(b,1E3)},title:"*",messageTop:"*",messageBottom:"*",exportOptions:{},header:!0,footer:!1,autoPrint:!0,customize:null};return i.Buttons}); PK ׁ�Zu)�E E css/buttons.bootstrap4.cssnu �[��� PK ׁ�Z�҂�� � � css/buttons.bootstrap4.min.cssnu �[��� PK ׁ�Z�ܫ��e �e � js/buttons.flash.min.jsnu �[��� PK ׁ�Z,�lϸ� �� �� js/dataTables.buttons.jsnu �[��� PK ׁ�Z1�R5� � �U js/buttons.print.jsnu �[��� PK ׁ�Z[x��O �O �i js/dataTables.buttons.min.jsnu �[��� PK ׁ�Z`9<a a ۹ js/buttons.html5.min.jsnu �[��� PK ׁ�Zf)��� �� $ js/buttons.flash.jsnu �[��� PK ׁ�Z|�2u u �� js/buttons.colVis.jsnu �[��� PK ׁ�Zy�LFx� x� �� js/buttons.html5.jsnu �[��� PK ׁ�Zf� j� js/buttons.bootstrap4.min.jsnu �[��� PK ׁ�Z�0,� ɗ js/buttons.colVis.min.jsnu �[��� PK ׁ�Z��צ '� js/buttons.bootstrap4.jsnu �[��� PK ׁ�Z+�o� � u� js/buttons.print.min.jsnu �[��� PK � `�
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0 |
proxy
|
phpinfo
|
Settings